Relative date filtering

[Peter_PL]

Hi,

Is there any easy way to filter "all past" by day and by weeks ?

"By day" I mean all dates prior to today and "by week" all dates prior to start of current week ?

Thanks in advance. 

[v-jiascu-msft · Accepted solution]

Hi @Peter_PL,

I would suggest using a Slicer and set the type to Relative. Please upgrade the Desktop to the latest version.

Best Regards,

Dale

[Peter_PL]

Thank you, I will test the slicer method this week.

However in relative date filtering a straightforward "IS IN" + "FUTURE/PAST" would be nice and easy.

[v-jiascu-msft]

Hi @Peter_PL,

Could you please mark the proper answer as solution?

Best Regards!
Dale