Date table Dates = VAR DAYS = CALENDAR ( DATE ( 2010| 1| 1 )| DATE ( 2025| 12| 31 ) ) RETURN ADDCOLUMNS ( DAYS| "YEAR"| YEAR ( [DATE] )| "MONTH NUMBER"| MONTH ( [DATE] )| "MONTH"| FORMAT ( [DATE]| "MMMM" )| "YEAR MONTH NUMBER"| YEAR ( [DATE] ) * 12 + MONTH ( [DATE] ) - 1| "YEAR MONTH"| FORMAT ( [DATE]| "MMM YY" ) )