Testing DAX measures by using AI
Marco Russo & Alberto FerrariThis 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
Creating DAX functions with AI to remove duplicated code
Code written by AI can contain many duplicate parts. User-defined functions are a great tool to simplify complex measures; this article shows how to leverage AI to build better DAX code. Read more
Oct 12-14 - Warsaw
Oct 27-29 - Lugano
Nov 9-11 - Atlanta
Nov 24-26 - London
Video Training
Introducing DAX Video CourseFree
Restoring alternating rows in Power BI matrices with Fluent 2
Marco RussoMicrosoft recently introduced a new default visual design style for Power BI named Fluent 2. I personally disagree with a few choices in the new defaults, including the removal of alternating row colors from Table and Matrix visuals. However, the… Read more
Analyzing the performance impact of visual calculations
Visual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance. Read more
DAX Patterns
Like-for-like comparison
The like-for-like sales comparison is an adjusted metric that compares two time periods restricting the comparison to products or stores with the same characteristics In this example we use the like-for-like technique to compare the sales of Contoso stores that… 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