Forum Discussion
Helper IChange to Financial Year
Hi. My company has been acquired. The new owner will change the financial year from year ending March 31st to year ending December 31st.
Whilst, I can change the financial year that I currently have this will inherently change the historical financial years which I do not want to do. Is there a way to build in a step change to the new financial year going forward from 1st April this year?
Thank you
HUlm1 , You can do that in calendar table
You can have code
if([Date] <date(2024,04,01), [Cal Year], [FY Year])
To calculate cal year and FY year you can check
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
Power BI Date Table: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=18180s
1 Reply
- amitchandak
Super User
HUlm1 , You can do that in calendar table
You can have code
if([Date] <date(2024,04,01), [Cal Year], [FY Year])
To calculate cal year and FY year you can check
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
Power BI Date Table: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=18180s