Topic: 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
-
Student questions: How to compute the sales amount of the previous date with a filter over weekdays? Learn why a filter below the month level may affect any time intelligence calculation! Watch now
-
Introduction to dynamic format strings feature released in Power BI May 2023, including a few technical details of its implementation. Watch now
-
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
-
At the end of March, we released the second update of SQLBI+ with a new session about different types of many-to-many relationships in DAX. The goal is to explain the difference between the many-to-many cardinality relationship available in Power BI… Read more
-
This article describes how to use the Group By Columns property to store the slicer selection by using the same column used in a SWITCH function to optimize the query performance. Read more
-
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
-
The second edition of the Optimizing DAX video course is available: new content, a new book, and some on the behind-the-scenes of the project. Read more
-
This article describes the possible rounding differences that can appear in DAX. They are related to the data types and the operation being performed: knowing these details helps you write more robust DAX formulas and avoid errors in comparisons. Read more
-
Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem. Watch now