This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month. Read more
We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE. Most of the times, you can move a filter from a SUMMARIZECOLUMNS argument… Read more
Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression. Read more
Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days. Read more