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

     

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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.