Forum Discussion
Populate calendar table fields between dates
This is my example pbix file. I have got Calendar table (first one below, only first 3 rows as example) created in DAX. Calendar =
ADDCOLUMNS(
CALENDARAUTO(),
"Year", YEAR ( [Date] ),
...
To report on things that are not there you need to use disconnected tables and/or crossjoins