How to use equivalent of CALENDARAUTO() in query editor?

[CloudMonkey]

Hi,

In the query editor please can you tell me how to automatically create a list of all calendar dates?

Thanks,

CM

[Phil_Seamark · Accepted solution]

Hi @CloudMonkey

Please try these steps

https://powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/

[v-sihou-msft · Accepted solution]

@CloudMonkey

Power Query can't automatically detect the date range within data model to generate list of dates, which means it can only work as CALENDAR() function so that you have to manually specify the start and end dates to create this calendar table. 

I suggest you create a calculated table with Power Query, group records with Max and Min aggregation, please refer to threads below:

https://www.experts-exchange.com/questions/28990135/Find-Minimum-and-Maximum-Dates-in-a-column-using...

https://community.powerbi.com/t5/Desktop/Power-Query-find-minimum-maximum-dates-across-multiple-tabl...

Then use Power Query to create a custom calendar based on the calculated table with StartDate and EndDate as Phil's provided article suggested. 

Regards,

[Phil_Seamark · Accepted solution]

Hi @CloudMonkey

Please try these steps

https://powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/