How to short Months by Financial Year

[Anonymous]

We want to represent the data as per the Financial year, Therefore, We want to start the months from April and ends with March.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Do you want to create fiscal year ?

Create a new column for Fiscal Year:

FY = IF(AND('Calendar'[Month]>=4,'Calendar'[Month]<=12),'Calendar'[Year]+1,'Calendar'[Year])

Hope this helps...

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

Create a month year sort column for month year

if(month([Date]) <=4, (YEAR([Date]) -1)*100 + month([Date]) +9, (YEAR([Date]) )*100 + month([Date]) -3)

for month sort

month Sort =

if(month([Date]) <=4, month([Date]) +9, month([Date]) -3)