topic Re: Selectedvalue of year - 1 in DAX Commands and Tips

Selectedvalue of year - 1

abeirne — Fri, 16 Dec 2022 18:36:12 GMT

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.

Re: Selectedvalue of year - 1

FreemanZ — Wed, 14 Dec 2022 23:58:30 GMT

Hi abeirne

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

Re: Selectedvalue of year - 1

abeirne — Fri, 16 Dec 2022 18:36:57 GMT

IF(

DISTINCTCOUNT(CalendarQ[Year]) > 1,

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

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

)
I used this measure and it worked