Forum Discussion
Filter By Year Dynamically
Hi, I ran into a dead end that I like my graph display the Year from Current Year and to the following 5 consecutive year (2018-2022) dynamically without having me filter or slice it manully each...
marcoslopezI tried that and it giving false result.
Column = IF(YEAR([Date]) >= YEAR(TODAY()),[Total],0)
Last 6 Years Filter = IF(AND(YEAR([Date]) >= YEAR(TODAY()) - 6,YEAR([Date}) <= YEAR(TODAY()) + 2), YEAR([Date}), 0 )
this is what iwe have to create a dynamic filter that looks at previous 6 years and future 2 years. Future dates as i use it in a forecast graph. Add it as a calculated column and apply as a filter, conditions for filter = 'is not 0'