Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |