Create a date table using the CALENDAR function

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]))




Discussion

0 comments