Solved: Re: Relative date filtering

Peter_PL · ‎01-24-2018

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 · ‎01-25-2018

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-jiascu-msft · ‎01-25-2018

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Peter_PL · ‎01-30-2018

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 · ‎02-07-2018

Hi @Peter_PL,

Could you please mark the proper answer as solution?

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.