topic Re: Dynamic date filter in DAX Commands and Tips

Dynamic date filter

Anonymous — Wed, 08 Jan 2025 19:45:03 GMT

Hi All,

I'm using Slicer visual in order to slice and dice dates :

I want to set the filter to auto update daily to show the dates of: (Today - 7) until (today - 1)

what should I set in the filter section:

Thanks !

Re: Dynamic date filter

lbendlin — Wed, 08 Jan 2025 21:51:34 GMT

Use the "Relative Dates" filter type instead, and choose "In the last 7 days".

Re: Dynamic date filter

Anonymous — Thu, 09 Jan 2025 02:37:17 GMT

Hi Anonymous ,

Thanks for the reply from lbendlin .

Create a measure to determine the range:

IsInRange = VAR TodayDate = TODAY() RETURN IF( MAX('Table'[Date]) >= TodayDate - 7 && MAX('Table'[Date]) < TodayDate, 1, 0 )

Drag IsInRange into the Filter and set the condition to IsInRange = 1.

The final visual effect is shown below:

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!