Implementing linear regression in Power BI
The LINESTX DAX function simplifies the calculation of linear regressions. This article explains the correct way to manage its results efficiently. Read more
The LINESTX DAX function simplifies the calculation of linear regressions. This article explains the correct way to manage its results efficiently. Read more
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
These 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
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
The ability to rank things is a very common requirement Finding the best customers computing the ranking position of products or detecting the countries with the best sales volumes are among the questions most frequently asked by management Ranking can… More on DAX Patterns
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