Livio/ January 30, 2020/ Power BI, Power Query/ 3 comments

Creating 4-5-4 Calendar with Power Query

This post is a continuation of the my previous post about how to create a 4-4-5. Please read here on how to use this function:

The M code I am sharing is one I have created which allows me to quickly and dynamically create a 4-5-4 calendar whenever I need it. 


Has this post helped you solve your problem? Please let me know in the comments and share with your friends!


  1. Thank you very much!!! I have a question, On 445 calendar there are some years with 53 weeks. Do you have any solution for that years?
    Than you again!

    1. Hi Gabriel! This is a natural consequence of having 53 weeks sometimes since a business year spans 364 days. Perhaps what you are after is not a 445 calendar?

  2. what if the year always starts on sunday?

Leave a Comment

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