If you are a Power BI user, you have created more than one calendar.
There are a lot of calendars you can create:
- A standard calendar
- A 445, 454, 544 and 13 weeks calendar
And of course, there are many ways to create them:
- Calendar in Power Query
- Calendar in DAX/ Powerpivot
There is no right or wrong here, your data will determine which calendar to use and how.
We have in Curbal’s YouTube channel explain all this into detail, so this is a summary of what it already has been covered there.
Sample files for all calendars are available on the comments box of each video!
So, lets begin!
Create a standard calendar in Power Query:
Create a calendar that self-generates and is self-configurable:
Create a 445,454,544 and 13 days calendar:
Create a calendar with DAX CALENDAR and CALENDARAUTO:
Create a calendar using the equivalent of CALENDAR in PowerQuery:
Download the sample files:
To download the file go to our download center *HERE*.