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
This pattern describes how to compute month-related calculations such as year-to-date same period last year and percentage growth using a month granularity This pattern does not rely on DAX built-in time intelligence functions You can use the Month-related calculations pattern… 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