Using visual calculations to highlight an entire row
Marco Russo & Alberto FerrariVisual calculations can be used efficiently to format visuals. This article presents an interesting technique to highlight a row based solely on the maximum value in the last column. Read more
SQLBI+ updates in April 2026
Marco RussoWe released a new session in SQLBI+: How to navigate the lattice of visual calculations: This video explains how to navigate the lattice of visual calculations in DAX, using COLLAPSEALL and EXPAND to move between levels. A key topic is… Read more
Jul 21-23 - Amsterdam
May 5-7 - Copenhagen
May 27-29 - Baltimore
Jun 10-12 - Zürich
Jun 15-17 - Berlin
Video Training
Introducing DAX Video CourseFree
The Third Edition of the Mastering DAX Video Course – unplugged
Alberto and I recorded an unplugged session to talk about the new edition of the Mastering DAX Video Course. You can watch it above, but if you prefer a quick read, here are some thoughts. The question we heard the… Read more
DAX user-defined functions (UDF) vs. calculation groups
This article describes the different roles of user-defined functions and calculation groups, explaining when to use either, and how they complement each other in the design of a semantic model. Read more
DAX Patterns
Comparing different time periods
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
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