Understanding context transition in DAX
Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it rather than be scared of it. Read more
Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it rather than be scared of it. Read more
Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns and/or calculated tables in your model, you should be aware that they… Read more
CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it. Read more
It is not common to face rounding differences in Power BI. However, when it happens, users are usually disappointed and surprised. Read more
The Dynamic segmentation pattern is useful to perform the classification of entities based on measures A typical example is to cluster customers based on spending volume The clustering is dynamic so that the categorization considers the filters active in the… More on DAX Patterns
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more