Forum Discussion
Solved
Fiscal 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
