fiscal year calculation

[Anonymous]

Hello,

I have a date column which contain date starting from fiscal month Nov to Oct.

Date

Nov-20

Dec-20

Jan-21

Feb-21

Mar-21

Nov-21

Dec-21

Jan-22

Feb-22

Mar-22

I would like to create custom column year which shows fiscal year

so my desired output will be

Date	Fiscal Year
Nov-20	2021
Dec-20	2021
Jan-21	2021
Feb-21	2021
Mar-21	2021
Nov-21	2022
Dec-21	2022
Jan-22	2022
Feb-22	2022
Mar-22	2022

[amitchandak · Accepted solution]

@Anonymous , In this blog I create all 12 months calendar and given links

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

Using year from start date of year and end date of year , you can get the above 

new columns

endofyear =endofyear('Date'[Date],"10/31")

FY= Format([Date],"mmm-YYYY") & format([endofyear], "YY")

[Anonymous]

Thanks @amitchandak