A simple daily average masks a level of complexity that may not be immediately apparent. In this article, we use AI to create a daily average, and then to analyze several edge-case scenarios to build a sound calculation. Read more
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
Currency conversion is a complex scenario where both the data model and the quality of the DAX code play an important role There are two kinds of currencies the currency used to collect orders and the currency used to produce… 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