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.
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