Trouble with 544 calendar rolling into subsequent years.

[Anonymous]

Hi Power BI Community,

I've trying to create a custom calender in Power BI for the calendar below, and whilst I've managed to recreate it for one year using some dax I've seen on this community, it doesn't rollover into the 2nd year the way that it should - Basically calender starts on Sunday 30/4/2023 and follows a 5-4-4 reporting month format to finish on Saturday 27/4/2024, so the following year starts on Sunday 27/4/2024 etc

Any suggestions please?

Thanks

Ewan

[audreygerred]

Hi! Marco Russo at SQLBI has shared a DAX calendar that handles a standard calendar, fiscal, or fiscal weekly where you can designate if you are following 454, 445, or 544. Here is a blog I wrote about it with a link to the pbix file you can download that has the DAX. I use this table in almost all of my solutions - it is very versitile! http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/