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 7
Time Intelligence: Building a Date Table
1
The Power of a Dedicated Calendar Table
Explain why a dedicated calendar table is a best practice for all time intelligence calculations
2
Building a Dynamic Date Table with CALENDARAUTO
Create a dynamic date table using the CALENDARAUTO function and mark it as a date table
3
DAX Date Table: Adding Time Intelligence Columns
Add useful columns to the date table (e.g., Year, Quarter, Month Name, Day of Week) using DAX
4
Date and Fact Table Relationship
Establish and verify the relationship between the date table and the fact table
Previous module
Iterator Functions (X-Functions) and Table Filtering
Next module
Time Intelligence: Period-to-Date and Comparisons