-
This article describes how to implement the comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or quarters in a calendar, such as seasons or campaigns. Read more
-
The blank value in DAX is a special value requiring particular attention in comparisons. It is not like the special null value in SQL, and it could appear in any conversion from a table expression. This article explores in details… Read more
-
This month we published a second draft of the Window functions in DAX whitepaper for the SQLBI+ subscribers. After the first draft we published in January 2023, we added new sections and updated others. We completely rewrote the “apply semantics”… Read more
-
Learn how to use calculation groups and how they work internally. The whitepaper is a companion to the related SQLBI+ video course. Read more
-
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
-
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
