Forum Discussion
Solved
need help
Hi All, Need your help i have 2 slicers one for year and one for month as shown in the below screenshot. when i select year 2021 the month slicer has to show only till June and for ...
Hi anithaMallam ,
You need to create a seperate year table. In the example I used DAX to create a chronology.
Table 2 = DISTINCT('Table'[Date].[Year])Then create the following measure
Measure = var _year=SELECTEDVALUE('Table 2'[Year]) return IF(YEAR(MAX('Table'[Date]))=_year,IF(_year=YEAR(TODAY())&&MAX('Table'[Date])>TODAY(),0,1),0)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi anithaMallam ,
You need to create a seperate year table. In the example I used DAX to create a chronology.
Table 2 = DISTINCT('Table'[Date].[Year])
Then create the following measure
Measure = var _year=SELECTEDVALUE('Table 2'[Year])
return IF(YEAR(MAX('Table'[Date]))=_year,IF(_year=YEAR(TODAY())&&MAX('Table'[Date])>TODAY(),0,1),0)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.