How to Create Year Filter - Fixing Minimum Year as 2012 and max automated year to year

[Dharanidharan_DD]

Hi friends,

How to Create Year Filter - Fixing Minimum Year as 2012 and max automated year to year.

Year:

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

For Next Year Max year have to change 2022 and min Year to be maintained 2012...

Please Give me a Solutions Friends... 

[MayilVahanan]

HI @Dharanidharan_DD 

Try like below in ur calendar

let vMaxDate = Floor(MakeDate(Year(Today(1)),12,31));

let vMinDate = MakeDate(2012,1,1);

[Dharanidharan_DD]

hi,

How to use it in the Selection / Filter pane

[MayilVahanan]

Hi

Try like below

=Aggr(Only({<Year={">=2012<=$(=Year(Today()))"}>}Year), Year)

[Digvijay_Singh]

This may also work - 

if(Year>=2012,Year) as dimension in the Filter pane