Creating functions for the like-for-like DAX pattern
Marco Russo & Alberto FerrariThis article offers a comprehensive guide to changing the like-for-like pattern into model-independent functions to enhance flexibility and simplify DAX code. Read more
SQLBI+ updates in March 2026
Marco RussoWe released a new course for SQLBI+ subscribers: Understanding Visual Calculations in DAX. This is not an introduction to visual calculations for users. The goal is to explain the details of implementing visual calculations for experienced DAX developers, including new… Read more
Jul 21-23 - Amsterdam
Mar 30-Apr 1 - Houston
May 5-7 - Copenhagen
Video Training
Introducing DAX Video CourseFree
Debugging DAX variables using TOJSON and TOCSV
This article describes how to use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure. Read more
Understanding DATEADD parameters with calendar-based time intelligence
The new calendar-based time intelligence functions offer greater flexibility than the classic time intelligence functions. This article describes the DATEADD parameters for controlling different granularity shifts. Read more
DAX Patterns
Custom time-related calculations
This pattern shows how to compute time-related calculations like year-to-date same period last year and percentage growth using a custom calendar This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal calendar… 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