Topic: DAX
-
A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This article describes the options available to create complex filters in DAX. Read more
-
This month we have a new video course and whitepaper for SQLBI+ subscribers: Inside Calculation Groups is available! This course is a deep dive into calculation groups in DAX. Although you might already be familiar with calculation groups, it is… 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
-
This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before starting, we suggest you read the previous articles in this series. 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