Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
DAX for Power BI Mastery
·
Module 9
Advanced DAX: Variables, Ranking, and Rolling Periods
1
Optimizing DAX with VAR/RETURN
Use variables (VAR/RETURN) to improve the readability, structure, and performance of complex DAX measures
2
Ranking with RANKX
Use the RANKX function to rank items (e.g., products) based on a measure
3
Rolling Totals with DATESINPERIOD
Write a measure to calculate a rolling total over a dynamic period (e.g., rolling 90 days) using DATESINPERIOD
4
Running Totals Over Date Periods
Write a generic running total measure over a date period
Previous module
Time Intelligence: Period-to-Date and Comparisons
Next module
Advanced DAX: Dynamic Measures and Conditional Logic