Phoenix (Tempe), AZ, USUsing RANK instead of RANKX in DAX
Marco Russo & Alberto FerrariShould you use RANK or stick with RANKX? In which scenarios is one better than the other? This article provides an in-depth analysis to help readers make informed choices. Read more
Model-dependent and model-independent user-defined functions in DAX
This article explains the distinction between model-dependent and model-independent DAX user-defined functions, highlighting how dependencies impact portability and maintenance, and provides guidance on avoiding hidden dependencies and adopting proper naming conventions. Read more
Jul 21-23 - Amsterdam
Video Training
Introducing DAX Video CourseFree
Find the products in the top 10 every year with DAX
This article outlines the process of creating a measure to identify the top 10 products by sales each year. Read more
Using VALUES in SUMMARIZE
This article describes when to use VALUES in a table grouped by SUMMARIZE, then goes on to explain why you cannot however use VALUES with SUMMARIZECOLUMNS. 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