Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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/
Proud to be a Super User! | |
User | Count |
---|---|
115 | |
106 | |
102 | |
78 | |
44 |
User | Count |
---|---|
142 | |
141 | |
124 | |
100 | |
57 |