dax

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

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…

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.

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

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...

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…

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 …

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

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

[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 blog post details how to create the default format string with calculation groups when no items are selected in Power BI

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

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

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

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

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

In this blog post, we are going to dive into the world of averages and how to solve problems when calculating averages by using CALCULATE, SUMMARIZE and AVERAGEX. Specifically, we look at creating …

There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.

This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. A circular dependency

A name is important. The right name is important. In this post, I reflect on the choice of names in the Microsoft BI stack. From time to time, a bad name ar

We are proud to announce great news for DAX Guide! Starting today, every DAX function has its own dedicated video. Moreover, we added new examples that you

I previously wrote a blog post explaining how to rename all columns in a table in one go with Power Query. One of my visitors raised a question in the comments about the possibility to rename all columns from all tables in one go. Interestingly enough, one of my customers had a similar requirement. So … Continue reading Quick Tips: Renaming All Tables’ Columns in One Go in Power Query

When I first started learning about Calculation Groups, I could certainly see how much potential this new DAX feature would eventually have. Out of the gate however, there were a limited number of …