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 8
Time Intelligence: Period-to-Date and Comparisons
1
Time Intelligence Calculations with TOTALYTD
Calculate Year-to-Date (YTD), Quarter-to-Date (QTD), and Month-to-Date (MTD) values using TOTALYTD and similar functions
2
Calculating Prior Year with SAMEPERIODLASTYEAR
Calculate a Prior Year measure using SAMEPERIODLASTYEAR
3
Calculating YoY Growth
Calculate Year-over-Year (YoY) growth in both absolute and percentage terms
4
Prior Month Calculation with DATEADD
Calculate a Prior Month measure using DATEADD
5
Calculating MoM Growth: Absolute & Percentage
Calculate Month-over-Month (MoM) growth in both absolute and percentage terms
6
Time Intelligence Functions Compared
Explain the functional differences between SAMEPERIODLASTYEAR, DATEADD, and PARALLELPERIOD
Previous module
Time Intelligence: Building a Date Table
Next module
Advanced DAX: Variables, Ranking, and Rolling Periods