Topic: DAX
-
This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters. Read more
-
This video shows how to create a like for like comparison in DAX comparing equivalent periods, and how to correctly implement a Boolean condition in a calculated column. Indeed, the presence of BLANK values in a Boolean expression might produce… Watch now
-
When you use a measure as a filter in a Power BI visual, the DAX code generated might display different behaviors depending on whether the measure is part of the values shown in the visual or not. In this article,… Read more
-
Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required. Read more
-
This video describes how we answer a question about an article: this time we show how to use the “Top N and others” report when there is a filter by date. Watch now
-
ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive and might result in inaccurate measures. In this article, we elaborate on… Read more
-
This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in Power BI and SSAS 2016. Read more
-
Create a running total formula in DAX that starts from arbitrary dates instead of considering the complete history available. Watch now
-
While ALLSELECTED and KEEPFILTERS are two very different DAX filter modifiers, in certain scenarios they seem to be alternatives to obtain the same result. Starting from a case like that, we clarify the differences between the two using several practical… Watch now
-
This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. Read more
