Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic Year Measure

Jolly Day, I currently have my visual set to just give me year 2021. I am wanting it to automatically update going two years back so I need it set to year 2022 when we begin year 2024. Is there a ...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could create a measure like

Year for TOPN =
VAR ChosenYear =
    SELECTEDVALUE ( 'Date'[Year] )
RETURN
    IF ( ChosenYear <= YEAR ( TODAY () ), ChosenYear )

and then add a TOPN filter to your visual on the Year column using this measure as the value and set it to only show the top 2