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.
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.
Hello, It's still not what I expected. Anywaya I have clarified fiscal calendar with Finance Team.
Everything until end of 2025 is OK. Change is applied only for first quarter of 2026. This means that first quarter is 5-4-5. Then January 2026 is starting in week 01 which is starting 28/12/2025 and finish 31/01/2025
Rest of quarters are 4-4-5:
- week 01 to week 05 - Jan 2026 - 5 weeks
- week 06 to week 09 - Feb 2026 - 4 weeks- week 10 to week 14 - Mar 2026 - 5 weeks
- week 15 to week 18 - Apr 2026 - 4 weeks
- week 19 to week 22 - May 2026 - 4 weeks
- week 23 to week 27 - Jun 2026 - 5 weeks
- week 28 to week 31 - Jul 2026 - 4 weeks
- week 32 to week 35 - Aug 2026 - 4 weeks
- week 36 to week 40 - Sep 2026 - 5 weeks
- week 41 to week 44 - Oct 2026 - 4 weeks
- week 45 to week 48 - Nov 2026 - 4 weeks
- week 49 to week 01/2027 - Dec 2026 - 5 weeks
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
Here is excel file with calendar which exactly need with DAX.
https://www.transfernow.net/dl/20260218wiNfXESd
Thank you for support.
Hi MKPartner
I have attached a sample PBIX that uses a financial calendar along with the DAX logic.
Hope this helps !!
Thank You.Hi MKPartner
Could you please let us know if any of the suggestions shared above helped to resolve the issue on your end ?