fiscal year in calendar wrong

[Anonymous]

hi all,
i have this calender,  which fiscal year start in apr..
but the fiscal is wrong, how can i change it?

For example:
5 April 2017 - should be fiscal year 2017 instead of 2018

Can anyone advice? Thank you.

[amitchandak · Accepted solution]

Try new column

Fiscal Year 1 = if(month('Date'[Calendar Date])>=4, year('Date'[Calendar Date]),year('Date'[Calendar Date])-1)

refer :https://www.dropbox.com/s/z3daqc4b1svgwyn/TestDate.pbix?dl=0

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601