Forum Discussion
Dynamic Year Measure
Jolly Day, I currently have my visual set to just give me year 2021. I am wanting it to automatically update go two years back so I need it set to year 2022 when we begin year 2024. Is there a way...
try to do this
1 create a new measure
Filter_DateTable_Year=IF(MAX(DateTable[Year])=YEAR(TODAY())-2,1,0)
2 add this measure to page filter, and filter the values equal to 1
try to do this
1 create a new measure
Filter_DateTable_Year=IF(MAX(DateTable[Year])=YEAR(TODAY())-2,1,0)
2 add this measure to page filter, and filter the values equal to 1
Thank you so much! Do you think you could break down how this is working?
it's like adding a column in the Date Table