New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Equivalent of CALENDARAUTO in Power Query

Do you want a calendar in Power Query that generates based on the sales or facts table?
In other words, do you need a calendar that generates itself like the CALENDARAUTO does but in Power Query?
Watch this tutorial to learn how to do this.

This is a copy of the code if you want to try it yourself:

//Get Max and Min date from oders table
MaxDate=List.Max(Orders[OrderDate]),
MinDate=List.Min(Orders[OrderDate]),
DaysDuration= Number.From(MaxDate-MinDate),

Watch the tutorial:

Equivalent of CALENDARAUTO in Power Query (M)
Was this helpful?
Previous Working hours without Holidays, weekends and by country in Power Query
Next Share calendars with your organization in Power BI

Reader Interactions

Let us know your thoughts...

Table of Contents