Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hello,
This was solved using lookupvalue. For some reason it was not working before and I tried again and now it is working
Current Fiscal Year = lookupvalue('Table'[Fiscal Year], 'Table'[Calendar Date], Today())
Last Fiscal Year = lookupvalue('Table'[Fiscal Year], 'Table'[Calendar Date], Today()) - 1
Hello,
This was solved using lookupvalue. For some reason it was not working before and I tried again and now it is working
Current Fiscal Year = lookupvalue('Table'[Fiscal Year], 'Table'[Calendar Date], Today())
Last Fiscal Year = lookupvalue('Table'[Fiscal Year], 'Table'[Calendar Date], Today()) - 1
Hi @yasemsem
Do you mean that if the current date is in February or January, the last fiscal year is returned, and if after February and the year is current, this fiscal year is returned?
Best Regards!
Yolo Zhu
Thank you Yolo Zhu
Not really. What I mean is that the fiscal year dates are dynamic.. it can end for example by 31st Jan or by 4th of Feb.
So what I need is a measure to identify current fiscal year based on the "Fiscal Calendar" table in the PBI file uploaded to below drive link:
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |