Using Power Query in Excel, how can you create a table of dates using the Calendar DAX function?
I tried using this starting a blank query and using the below function:
Test_Calendar:=CALENDAR(DATE(2005,1,1),DATE(2005,12,31)) but this does not seem to produce any results.
Test_Calendar:=CALENDAR(DATE(2005,1,1),DATE(2005,12,31))
2.1m questions
2.1m answers
60 comments
57.0k users