Forum Discussion
amandabus21
Helper V
Helper VFiscal Year / Calendar Year
Hi, I need help creating a new column in Power Query where I create a Calendar Year. Our fiscal year begins in July. Id like a column named "Calendar Year" Thanks!
You can create a custom column with this expression.
= if Date.Month([Merged])>6 then Date.Year([Merged]) + 1 else Date.Year([Merged])
Pat
ppm1
Solution Sage
Solution SageYou can create a custom column with this expression.
= if Date.Month([Merged])>6 then Date.Year([Merged]) + 1 else Date.Year([Merged])
Pat
amandabus21Hi, ppm1
I ran into an issue with this.
The calendar year should be "2022" not 2024.
Thank you for your help!
- amandabus21
ppm1 was able to fix with "-1" instead of "+1" thank you!
How would I change this to be the first monday in april?
