Hi,
I have a Date Slicer and want it to switch between 2024 and 2025.
Switching to 2024 is no problem, that works fine.
The problem starts with switching back to 2025...
I've tried setting a filter (is 1) for the slicer for the 2025 bookmark, but it's not dynamic.
Date_Filter=
IF(
'MaxDatum'[LetztesDatum] >= DATE(2025,1,1) && 'MaxDatum'[LetztesDatum] <= TODAY() - 1,
1,
0
)
The idea is simply that when the date is updated, that it still shows the today-1 date on the slicer when I click the 2025 button.
I don't know if this can be done diretly somehow on the slicer or rather with a DAX-Measaure?
Any help is much appreciated! 🙂
