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

Create a custom calendar in Power BI using Power Query

Here I show you how to create a custom calendar in Power BI.

Table of contents:

00:00 Intro
00:20 Why a calendar is needed in Power BI
02:00 Start creating the calendar
02:40 Copy the power query code
03:20 How to change the dates to match your needs
05:10 How to change year month column
05:50 How to sort the calendar columns
08:00 Hide sort columns

Watch the tutorial:

Create a custom calendar in Power BI using Power Query

Links to the mentioned resources

Download the calendar file: https://curbal.com/blog/create-power-…

Was this helpful?
Previous Create a Date/Time calendar
Next Equivalent of CALENDARAUTO in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents