-
This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before starting, we suggest you read the previous articles in this series. Read more
-
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 typical on Internet forums. I know it is depressing not to… Read more
-
This article describes the syntax and the use cases of the DEFINE COLUMN statement in DAX. Read more
-
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 the other products. The companion video introduces the scenario and the general… Read more
-
This article describes the syntax and the use cases of the DEFINE TABLE statement in DAX. Read more
-
We are launching a new series of videos that we refer to internally as the “unplugged”. Why did we choose to set this series apart from the rest? You see, we usually publish videos with a specific topic and goal:… Read more
-
Data lineage is such a well-implemented DAX feature that most developers use it without knowing about it. This article describes data lineage and how it can help in producing better DAX code. Read more
-
This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. Read more
-
At the end of a year marked by the pandemic, it is time for our usual review of what happened in the DAX realm. The enthusiasm we typically demonstrate in this traditional end-of -year post is tainted this year by… Read more
-
The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. This article explains these side effects and how to write correct DAX code to avoid getting incorrect results. Read more