Perth, WA, AUImplementing linear regression in Power BI
Marco Russo & Alberto FerrariThe LINESTX DAX function simplifies the calculation of linear regressions. This article explains the correct way to manage its results efficiently. Read more
Introducing dynamic format strings for DAX measures
Power 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
Jun 27-29 - Amsterdam
Video Training
Introducing DAX Video CourseFree
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
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
DAX Patterns
Week-related calculations
This pattern describes how to compute week-related calculations such as year-to-date same period last year and percentage growth using a week granularity This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal… 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