DAX

This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all

This article describes the syntax and the use cases of the DEFINE COLUMN statement in DAX. Introduced in December 2020, the DEFINE COLUMN statement lets you

How many times did you ask a technical question, to be met with a laconic “it depends”? Or worse, for your question to be totally ignored? This is so ty

“DirectQuery for Power BI datasets and Analysis Services” is the name of a new feature released in December 2020 that we simply call… R

This article describes the syntax and the use cases of the DEFINE TABLE statement in DAX. Introduced in December 2020, the DEFINE TABLE statement lets you d

If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. A Cumulative discount i…

This blog post details how to create the default format string with calculation groups when no items are selected in Power BI

[vc_row][vc_column width="1/1"][vc_single_image media="88035" media_width_percent="100"][vc_column_text]Watch the video above to learn how to set up a visual with a dynamic date axis […]

This article shows how to use calculation groups to change the active relationship in a model in order to let users choose among multiple dates. It is commo

Calculating and visualizing semi- and non-additive measures like distinct count in Power BI is usually not a big deal. However, things can become challenging if your data volume grows and exceeds the …

This article describes the behavior of the DAX functions that manipulate sets; they are useful to create queries and sometimes also to author measures. In t

I am not trying to take Microsoft out of business, but after I read on the Power BI team’s blog that the anomaly detection feature was coming, I decided to see if I could implement something …

As the name suggests, a multi-kpi comparator allows you to compare multiple KPIs or measures on the same chart. This way you can dramatically reduce the clutter on your Power BI report page. You ca…

Compare DAX and M formulas in Visual Studio Code is really easy with the help of Power BI Sidetools. As it is possible to transfer DAX and M formulas from Power BI desktop to files and to open them in Visual Studio Code, it is possible to compare two files. That’s extremely useful in many cases. Y...

This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Many DAX newbies use

When looking to create dynamic column headers in tables and matrix in Power BI. This is one way where it will always change with your dates.

Imaging a scenario where your monthly sales are $80 while the budge value for sales was supposed to be $100. Obviously, you are not making your number. However, would you rather be 20% short but wi…

Calculation groups are a robust modeling feature in Power BI that reduces redundant measures created by grouping standard measure expressions.

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

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

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’…

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…

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

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…

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 »

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 »

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…