- Help Center
- Power BI
-
Data Science Bootcamp
-
Large Language Models Bootcamp
-
Agentic AI Bootcamp
-
Registration
-
Pricing
-
Community
-
Python Programming
-
Platform Related Issues
-
Bootcamps
-
Homework and Notebooks
-
Free Courses
-
Data Science for Business
-
Practicum
-
Blog
-
Employment Assistance
-
Machine Learning
-
Data Analysis
-
R Language
-
Python for Data Science
-
SQL
-
Introduction to Power BI
-
Power BI
-
Programming and Tools
-
Partnerships
How would you create trailing X month metrics via DAX against a non-standard calendar?
The solution will involve:
CALCULATE function to control (take over) filter context of measures.
ALL to remove existing filters on the date dimension.
FILTER to identify which rows of the date dimension to use.
Alternatively, CONTAINS may be used:
CALCULATE(FILTER(ALL(‘DATE’),…….))