Selectedvalue of year - 1

[abeirne]

Hi all, I am trying to show the year prior to the selected year. 

SELECTEDVALUE(CalendarQ[Year])-1 & " " & "Golf Rev"

I use this measure in a textbox for a tooltip. This measure works for next year but not the current year. Any thoughts on how to fix this? Thanks.

[abeirne · Accepted solution]

IF(

    DISTINCTCOUNT(CalendarQ[Year]) > 1,

    YEAR(TODAY()) - 1  & " Golf Rev",

    SELECTEDVALUE(CalendarQ[Year]) - 1 & " Golf Rev"

)
I used this measure and it worked

[FreemanZ]

Hi @abeirne 

do you have 2021? could it be filtered out unintentionally by filters like slicer, filter pane, or other visuals?