Forum Discussion
Solved
Tweaking Financial Calendar
Good morning All, Our company has change financial calendar. This means that January is starting since 5th of January (calendar week 02) and month closed is in 30th of January (calendar week 05)...
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,
You mention that all dates prior to this are correct. The main issue is that your current code assumes that every year has exactly 364 days (52 weeks).
"Year No" = QUOTIENT( DATEDIFF(Minx(_cal, [Date]), [Date], day) ,364)+1
"Week" = Mod(QUOTIENT( DATEDIFF(Minx(_cal, [Date]), [Date], day) ,7),52)+1
``When you introduce a 53rd week, this assumption no longer holds, because the 2025 financial year is no longer 364 days long. Below is one way to adjust the logic while keeping most of your original approach, treating 2025 as a special case with 53 weeks.
recommended reed post by amitchandak
Solved: Financial Year Calendar - Microsoft Fabric Community
If this response was helpful in any way, Iād gladly accept a šmuch like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop š.