• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / Microsoft Power BI / Create Power BI custom calendars
Create Power BI custom calendars

Create Power BI custom calendars

posted on February 2, 2017

If you are a Power BI user, you have created more than one calendar.

There are a lot of calendars you can create:

  1. A standard calendar
  2. A 445, 454, 544 and 13 weeks calendar

And of course, there are many ways to create them:

  1. Calendar in Power Query
  2. 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:

#D29 - A configurable and self generated calendar in Power BI

Create a calendar that self-generates and is self-configurable:

Create a custom calendar in Power BI using Power Query

Create a 445,454,544 and 13 days calendar:

Create a custom 4-4-5 calendar that self-generates in Power BI - Power BI Tips & Tricks 23

Create a calendar with DAX CALENDAR and CALENDARAUTO:

DAX Fridays! #2: CALENDAR, CALENDARAUTO

Create a calendar using the equivalent of CALENDAR in PowerQuery:

Equivalent of CALENDARAUTO in Power Query (M)

Download the sample files:

To download the file go to our download center *HERE*.

Filed Under: Microsoft Power BI

Join our community of over 50,000 professionals

Become a Member

Subscribe to YouTube

Reader Interactions

Comments

  1. Paul

    January 16, 2019 at 9:36 pm

    Hi,

    I have a calendar table that goes up to December 31st, 2018. How can I extend it please? Here is how it was created:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(“(lots of gibberish)”, BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Calendar = _t]),
    #”Changed Type” = Table.TransformColumnTypes(Source,{{“Calendar”, type date}})
    in
    #”Changed Type”

    And the last few lines of data in the table:

    2018-12-25
    2018-12-26
    2018-12-27
    2018-12-28
    2018-12-29
    2018-12-30
    2018-12-31

    Reply
    • Ruth Pozuelo Martinez

      January 16, 2019 at 10:30 pm

      It looks hard coded, use mine instead.
      /Ruth

      Reply
  2. Aziz Quazi

    October 14, 2018 at 6:47 am

    Cannot download the PBIX file – looks a common issue here.

    Rgds..Aziz

    Reply
    • Ruth Pozuelo Martinez

      October 15, 2018 at 5:54 pm

      Hi,
      I have created a download center where you can get all my pbi files in one place. Here it is:
      https://curbal.com/donwload-center
      /Ruth

      Reply
      • Larry Heimendinger

        January 10, 2019 at 10:20 pm

        I tried this for a 2019 calendar starting Feb 3 and get error on load ‘increment’ argument is out of range. Does your template go out to 2019? are you going to update it?

        Better still do you have a template to create an Excel spreadsheet for 2019 4-5-4 calendar? I want to get this into a SharePoint calendar or list and Excel makes it easy, albeit an extra step if I could go straight to SharePoint. Thanks

        Reply
  3. Sanjeev Soni

    October 10, 2018 at 4:18 pm

    What is the best recommendation to use 445 or 544 or 454 calendar for developing data model

    Reply
    • Ruth Pozuelo Martinez

      October 11, 2018 at 11:22 am

      That is for the business to decide. Ask them which one they need!
      /Ruth

      Reply
  4. David Burke

    June 8, 2018 at 6:08 pm

    This is awesome! I tried to change the parameters to begin in 2012, Month 1 (January), Date 1 (1st), and day 0 (Sunday). The underline data that gets generated is a bit messed up? Am I missing something?

    Reply
    • Ruth Pozuelo Martinez

      June 11, 2018 at 12:37 pm

      Hi,
      It my have to do with your regional settings. Check every step in power query to see what makes the query break.
      /Ruth

      Reply
  5. cellurl

    April 10, 2018 at 6:54 pm

    gofile.me website is not accessible from my work. Can you perhaps put it somewhere else and let me know and I will try it out. I work for one of those big scared companies, but I suspect other people can’t get to gofile.me as well.

    Thanks for great tutorial anyway… Also, you might become famous and explain 445 calendar on wikipedia.org page which doesn’t explain 445 at all!

    https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar

    Reply
    • Ruth Pozuelo Martinez

      April 13, 2018 at 10:43 am

      HI,
      I will try to get the files somewhere else. 🙂
      /Ruth

      Reply
  6. Norman Emmanuel Cordova

    March 12, 2018 at 2:19 pm

    Hi Ruth,

    I have a scenario that our 2017 FY calendar has a 455 pattern for the 1st Quarter and 445 pattern for 2nd, 3rd, and 4th Quarter.
    and the same thing with our 2018 FY calendar.

    need your help on how to deal with this matter. let me know if it’s OK with you that I’ll send a sample of our FY calendars.

    More power.

    I hope you could spare some time and hope to hear from you soon inspite of your busy schedule

    Thank you in advance.

    *NOTE: perhaps you could add a upload button/link on your Blogs.

    regards,
    Norman

    Reply
  7. Bill Paxton

    May 23, 2017 at 7:04 pm

    could you do a video on how to split a column that has 40.000gals on one row and 6.256oz on another in powerbi

    Reply
    • Ruth Pozuelo Martinez

      June 9, 2017 at 12:24 pm

      Hi Bill,
      Can you provide more details as what you are trying to achieve?
      /Ruth

      Reply
  8. Julian

    May 17, 2017 at 2:47 am

    No matter what parameters i entered I always got the error message saying “The ‘increment’ argument is out of range.
    ” What’s wrong with it? Please comment.

    Reply
    • Ruth Pozuelo Martinez

      June 9, 2017 at 12:23 pm

      Hi Julian,
      I have sample files for you to download on all the calendars. The download file is in the description box of the videos. Have you tried them to see how they differ from yours?
      /Ruth

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel (+130k subs)!

Apply for Membership (+50,000 members)

Become a Member

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In