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 way to accomplish this? I created a year column that just parsed the year from my date so we also have the full date to work with. Any help with this would be greatly appreciated! 

 

 

Thanks in advance,
Idon'tquitegotthepowerBI

1 Reply

  • johnt75's avatar
    johnt75
    Super 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