Here's the first DAX example:
Attendance Dates = CALENDAR(DATE(2009,01,01),TODAY())
This is the DAX I used to create my final calendar table:
Attendance Dates = CALENDAR(MIN('Attendance Marks'[Mark date]),MAX('Attendance Marks'[Mark date]))
0 comments