The 2nd Edition of #25daysofdaxfridays challenge is 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?

Reader Interactions

Let us know your thoughts...

Table of Contents