Fiscal Year Age Dax Calendar Table Calculation

[Woody2022]

Hi There, 

I am having some issues trying to calculate a Fiscal Year Age in my DAX Calendar table.

I have created a line to calculate my fiscal year - "Fiscal Year", if(month([Date])<4,Year([Date])-1,Year([Date])

I need another line to show Fiscal Year Age, So for example March 2022 (Last FY) would be "-1"  and April 2022 (Current FY) would show as "0" 

Appreciate any help

Thanks

[Woody2022]

Thanks v much

[v-xiaotang · Accepted solution]

Hi @Woody2022 

You can try this, 

Best Regards,

Community Support Team _Tang

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