Perth, WA, AUIntroducing dynamic format strings for DAX measures
Marco Russo & Alberto FerrariPower BI introduced dynamic format strings in May 2023. In this article, we briefly introduce this functionality and then dive into a few technical details of its implementation. Read more
Generative AI guidelines at SQLBI
Marco RussoThese are pivotal times with the large adoption of new technologies like generative AI systems that will certainly impact how we work, along with a lot of other things. If you look at how Alberto and I answer questions related… Read more
Jun 27-29 - Amsterdam
Video Training
Introducing DAX Video CourseFree
Explaining REDUCED BY in xmSQL batch events
We recently released the second edition of the Optimizing DAX video course. Despite its volume, some details always did not find space in the training material. The REDUCED BY syntax of xmSQL is one of those details. Read more
Optimizing text search in DAX
This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro… Read more
DAX Patterns
Parameter table
The parameter table pattern is used to create parameters in a report so that users can interact with slicers and dynamically change the behavior of the report itself For example a report can show the top N products by category… More on DAX Patterns
SQLBI Corp.
DAX Patterns, Second Edition
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more