Slicer or Filter to only look backwards

Hi @gkavesh. Absolutely … but before doing any time intelligence, you should mark your dates table as a date table. Once that is done, you can add an [Is After Today] column to your Dates table (something like IF(Dates[Date] > TODAY(), 1, 0 )), then add a report or page filter for [Is After Today] = 0.

If it was me, I’d use the excellent Enhanced Date Table from Enterprise DNA expert @Melissa, which already has such an [IsAfterToday] column, and which can be found at
Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum

Greg