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: https://xcelanz.com/creating-a-4-4-5-calendar-with-power-query/

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!

3 Comments

  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 *

*
*