Topic: Power BI
-
When a slicer contains many items, developers can filter the most relevant items using another slicer. The scenario is easily solved with a many-to-many relationship if the source is a regular table. Still, it requires some DAX coding if the… Read more
-
UPDATE 2023-07-09: we now have a section “Creating sets of calculation items and measures” in the Inside Calculation Groups published in June 2023 that describes a technique also mentioned in the comments of this blog post. The consumption experience following… Read more
-
RANK is a new DAX function to rank items based on multiple columns. This article introduces the RANK function and its differences with RANKX. 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
-
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
-
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