Where we stand on AI and DAX in 2026
Marco RussoThe time has come: in 2026, using AI to write DAX has started to be effective. Let me recap what has changed between 2023 and 2026, and what we are doing with our three new courses to best assist you… Read more
The hidden complexity of a daily average in DAX
Marco Russo & Alberto FerrariA 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
Oct 12-14 - Warsaw
Oct 27-29 - Lugano
Nov 9-11 - Atlanta
Nov 24-26 - London
Video Training
Introducing DAX Video CourseFree
Writing DAX at the correct granularity
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
Testing DAX measures by using AI
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
DAX Patterns
Events in progress
The Events in Progress pattern has a broad field of application It is useful whenever dealing with events with a duration - events that have a start date and an end date The event is considered to be in progress… More on DAX Patterns
Microsoft Press
The Definitive Guide to DAX, Third Edition
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