Forum Discussion

Peter_PL's avatar
Peter_PL
New Member
8 years ago
Solved

Relative date filtering

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's avatar
    v-jiascu-msft
    8 years ago

    Hi Peter_PL,

     

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

    Relative_date_filtering

     

    Best Regards,

    Dale

     

Peter_PL's avatar
Peter_PL
New Member
8 years ago

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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Peter_PL,


Could you please mark the proper answer as solution?

 

Best Regards!
Dale