topic Fiscal Year Age Dax Calendar Table Calculation in DAX Commands and Tips

Fiscal Year Age Dax Calendar Table Calculation

Woody2022 — Fri, 10 Jun 2022 08:10:10 GMT

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

v-xiaotang — Mon, 13 Jun 2022 03:19:57 GMT

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.

Woody2022 — Thu, 16 Jun 2022 07:38:41 GMT

Thanks v much