A DAX calculation can produce convincing values at the detail level and still fail at the total. The problem is often not the total itself: the business rule was evaluated at the wrong granularity. This article introduces four grains, or… Read more
This article describes how to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure. Read more
Code written by AI can contain many duplicate parts. User-defined functions are a great tool to simplify complex measures; this article shows how to leverage AI to build better DAX code. Read more
Microsoft recently introduced a new default visual design style for Power BI named Fluent 2. I personally disagree with a few choices in the new defaults, including the removal of alternating row colors from Table and Matrix visuals. However, the… Read more
This pattern is a useful technique to compare the value of a measure in different time periods For example we can compare the sales of the last month against a user-defined period The two time periods might have a different… More on DAX Patterns
The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel.
Read more
Marco Russo & Alberto Ferrari
Oct 12-14 - Warsaw
Oct 27-29 - Lugano
Nov 9-11 - Atlanta
Nov 24-26 - London
Marco Russo