Forum Discussion
Solved
Fiscal Year
Hi I have created a date table in power query using list.dates I want to add in the financial year to this table in the format yyyy/yy e.g. 2018/19 I have the calendar year, calendar mo...
Use this formula in a custom column where 3 means FY finishes in March month. Similarily say your financial year finishes in Jun month, replace 3 with 6..If it finishes in Jul, replace 3 with 7.
You will need to replace [Year] and [Month] fields appropriately by calendar year and calendar month
Text.From([Year]-Number.From([Month]<=3))&"/"&Text.End(Text.From([Year]+Number.From([Month]>3)),2)
Use this formula in a custom column where 3 means FY finishes in March month. Similarily say your financial year finishes in Jun month, replace 3 with 6..If it finishes in Jul, replace 3 with 7.
You will need to replace [Year] and [Month] fields appropriately by calendar year and calendar month
Text.From([Year]-Number.From([Month]<=3))&"/"&Text.End(Text.From([Year]+Number.From([Month]>3)),2)Thank you so much Vijay_A_Verma this solution worked perfectly 🙂
