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
Time patterns
This post introduces the four time-related calculations patterns presented in this website The goal here is to help you choose the right pattern based on your specific needs Indeed when it comes to time-related calculations the choice of the pattern… 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