Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Thanks v much
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.