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.
Designing a dashboard for a college. Their academic years span two calendar years.
Eg:
I would like to create a set of measures where I only have to update the measure for the most recent year. For example:
Then have a measure that reads that string in [Last Year] and creates academic year -1 automatically. For example:
Essentially preventing the need to up date all the measures for each year. I hope this makes sense.
Solved! Go to Solution.
Hi @cwfmoore
Try this measure:
Last year (minus 1) =
Var _Year1 = left([Last Year],4)-1
Var _Year2 = Right([Last Year],2)-1
return
_Year1&"-"&_Year2
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @cwfmoore
Try this measure:
Last year (minus 1) =
Var _Year1 = left([Last Year],4)-1
Var _Year2 = Right([Last Year],2)-1
return
_Year1&"-"&_Year2
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Perfect, thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
34 | |
27 | |
25 | |
24 |