dax

Objective: We would like to have WTD(Week Till Date) Last WTD and This Week vs Last Week. Dataset: We have taken Sales data. The data is from April 2018 till April 2020. We have created a date Calendar. Steps: We create a Date Calendar With Monday to Sunday Week, with the following week-related...

For someone utterly new to Power BI, and especially for those who have been using Excel, understanding DAX can be an overwhelming experience. At least, it was for me. It took me some time to grasp the concepts, filter and row contexts, and the CALCULATE function. One of the standard requirement...

A quick post today. Sometimes you will be mystified why your aggregations are not getting hit. There is no clear-cut answer to why. The best way to find the underlying...

We are working hard at Enterprise DNA to build a number of tools that can assist Power BI users in their development work. Today we are excited to announce the release of our DAX Clean Up Tool Why a new tool to format DAX formulas? One of the biggest hurdles that any Power BI user faces when they start developing reports and dashboards is attempting to understand how DAX formulas and DAX code work. WeContinue reading

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

This article describes how to optimize a slow Power BI report that has a large number of card visuals, by obtaining the same graphical layout with a smaller

The more complex a Power BI Custom Data Connector gets, the more cumbersome the main Power Query file becomes. Without the ability to make a true “project” structure and include or dire…

There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the image below – do you see it? Note the “new” function buttons? When I say [...]Read More »

This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation

This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Conditional forma

I recently came across an interesting problem regarding how you can show the sum of values of certain selected categories as separate bars in a bar chart – but with the sum of all the non-sel…

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here it …

This blog post lists the new financial DAX functions introduced in June 2020.

A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division

In my last tutorial here, you learned how to apply a dynamic running average in DAX. In this part, you will learn how to offset the daily new confirmed cases vertically and horizontally. Horizontal offset - Normalize cases by population Different countries were affected differently by COVID-19. The most common analytic challenge in comparing between…

In my last tutorial here, you learned how to apply a What-If technique to calculate the estimated active cases of COVID-19. In this part, you will learn how to run running averages to smooth the trend lines of any measure you use. Our analytics objective is simple. The daily new COVID-19 confirmed cases can fluctuate…

DAX Fusion Optimising Power BI

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here i…

in this video I talk about the fatal flaw of the Power BI’s Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch …

Date functions in Power BI are not always easy. And sometimes they can be a little confusing… And sometimes, a little more than just a little.. For no other reason than pure serendipity, I have dec…

I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to [...]Read More »

I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc. As is often the case, I thought it would be a great blog article that I [...]Read More »

Let’s say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot the…

LAUNCH OFFER: the books on Amazon, Apple, and Google stores have a reduced price (35% discount) until August 31, 2020. Starting September 1, 2020, the ebook

I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let's see how this is possible. Sample model I have a…

You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’…

This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Starting from the July 2020

This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. This article contains a