Forum Discussion
Tweaking Financial Calendar
Hi MKPartner
I have attached a sample PBIX that uses a financial calendar along with the DAX logic.
Hope this helps !!
Thank You.
Thank you for your help. We are pretty OK. This means that 2026 year is OK as I expected, but previous year which where OK, no are NOK. Some weeks are overlapping for two months.
Screen for Feb 2026:
Screen for Feb 2025 -> week 9 in 2025 was in March 2025
Screen for March 2025 -> week 14 in 2025 was in April 2025
Actual calendar and expected in excel.
you highlighted two columns. I can find out the difference, however, can't understand the logic.
i created one column for you, pls see the attachment below.
Thank you but everything was change before December 2025 in WC_Month column.
My logic is to keep everything the same since January 2018 until December 2025.
December 2025 in WC_column needs to cover WK01 in January 2026 so this still needs to be December 2025. I'd like to start with January 2026 in WC_Month column since WK02 2026 starting from Sunday 04/01/2026.Our fiscal calendar was changed on the end of last year. We are starting each week on Sunday and finish on Saturday.
In our fiscal calendar for 2026 like week 53 of 2025 but I cannot have week 53. I need to have week 01:
Our fiscal calendar:
- week 01 2026 (28/12/2025 - 03/01/2026) is still December 2025
- week 02 to week 05 - Jan 2026
- week 06 to week 09 - Feb 2026- week 10 to week 14 - Mar 2026
- week 15 to week 18 - Apr 2026
- week 19 to week 22 - May 2026
- week 23 to week 27 - Jun 2026
- week 28 to week 31 - Jul 2026
- week 32 to week 35 - Aug 2026
- week 36 to week 40 - Sep 2026
- week 41 to week 44 - Oct 2026
- week 45 to week 48 - Nov 2026
- week 49 to week 52 - Dec 2026