Forum Discussion
Dynamic Slicer
Hello, In key Measure, I have the current year=year(today()) and year before=current year - 1. Also, I have a table Dim Calendar which contains dateskey for each day, the fiscalyear and other...
you can try with the relative filter - last 2 years
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
you can try with the relative filter - last 2 years
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range