Change academic year text from 2021-22 to 2020-21 in a DAX measure?

[cwfmoore]

Designing a dashboard for a college. Their academic years span two calendar years.

Eg:

• 2021-22
• 2020-21
• 2019-20

I would like to create a set of measures where I only have to update the measure for the most recent year.  For example:

• Last year = "2021-22"

Then have a measure that reads that string in [Last Year] and creates academic year -1 automatically. For example:

• Last year (minus 1) = "[Last Year 20(21 - 1) - (22 - 1)]"
• Resulting in Last year (minus 1) = "2020-21"

Essentially preventing the need to up date all the measures for each year.  I hope this makes sense.

[VahidDM · Accepted 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!! 

LinkedIn | Twitter | Blog | YouTube 

[cwfmoore]

Perfect, thank you!