Forum Discussion
Solved
Slicer max date
I have a slicer set up with Fiscal Yr, Qtr, and Mon from a dim date table. I want this slicer to have a max date of the last month (Data is updated at every month beginning, with last months data). ...
Hi Dev_B_PBIing ,
According to your description, here are my steps you can follow as a solution.
(1) We hava a date table.
Date = CALENDAR( DATE(2022,1,1),DATE(2025,12,31))(2) We can create a measure.
Flag = IF(MAX('Date'[Date])<= EDATE(TODAY(),-1),1,0)(3) Screening of slicer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dev_B_PBIing ,
According to your description, here are my steps you can follow as a solution.
(1) We hava a date table.
Date = CALENDAR( DATE(2022,1,1),DATE(2025,12,31))(2) We can create a measure.
Flag = IF(MAX('Date'[Date])<= EDATE(TODAY(),-1),1,0)(3) Screening of slicer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That worked! Thanks so much!
