Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a financial year column which outputs the financial year of the record we store (e.g FY21/22)
The financial year runs from 1st September to 31st August.
What I'd like, if possible, is to have a flag that outputs "current fy" and "previous fy" based on the date range above.
So, as of today, FY20/21 will show "previous fy" and FY21/22 will show "current fy".
And when we move to 1st September 2022, that will show as "current fy" and FY21/22 will change to show "previous fy" and FY20/21 will then show as "blank".
Solved! Go to Solution.
We need 2 date marks: start_of_currentFY and start_of_previousFY to define flag
measure start_of_currentFY =
We need 2 date marks: start_of_currentFY and start_of_previousFY to define flag
measure start_of_currentFY =
Thank you so much for your help, I really do appreciate it.
User | Count |
---|---|
83 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |