Topic: DAX
-
This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. Read more
-
You can implement the calculation of stock inventory over time in several ways in DAX. The xVelocity technology in Power Pivot and Analysis Services Tabular is so fast that you might consider both dynamic calculation and snapshot-based calculation, depending on… Read more
-
SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. Read more
-
This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. Read more
-
This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total value in the filter context of the total. Read more
-
In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. Read more
-
This article introduces the new DAX syntax (March 2021) to support CALCULATE filter predicates that reference multiple columns from the same table. Read more
-
Rolling averages over time (a.k.a. moving averages or running averages) are useful to smoothen chart lines and to make trends more evident. This article shows how to compute a rolling average over 12 months, in DAX. Read more
-
This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic. Read more
-
The SQL functions IN and EXISTS are useful to implement tests over a set of values. This article describes the corresponding syntax in DAX language. Read more