This article describes the parameter types available in DAX user-defined functions, focusing on the specialized reference types MEASUREREF, COLUMNREF, TABLEREF, and CALENDARREF. Read more
Visual 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
We 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
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
The static segmentation pattern classifies numerical values into ranges A typical example is the analysis of sales by price range You do not want to slice the data by individual price instead you want to simplify the analysis by grouping… 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
Jul 21-23 - Amsterdam
May 5-7 - Copenhagen
May 27-29 - Baltimore
Jun 10-12 - Zürich
Jun 15-17 - Berlin
Marco Russo