Forum Discussion

Treyson's avatar
Treyson
Advocate I
9 years ago
Solved

Filtering records in a sliding date range

I am looking for a way to filter out records in a dynamic range of dates.

 

So for example, We want to remove all SKUs that only appear once in that sliding date range.

 

EDIT* By sliding date range, I mean one of these.

 

Need Help
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    9 years ago
    Hi Treyson,

    If you want to show the ones that have a SKU count above one you need to add measure like this:

    CALCULATE (COUNT(Table[SKU]), ALLSELECTED(Table[Date]))

    Add this to your visual filters and select all the ones that are different from 1.

    Regards,
    MFelix

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago
    Hi Treyson,

    If you want to show the ones that have a SKU count above one you need to add measure like this:

    CALCULATE (COUNT(Table[SKU]), ALLSELECTED(Table[Date]))

    Add this to your visual filters and select all the ones that are different from 1.

    Regards,
    MFelix
    • Treyson's avatar
      Treyson
      Advocate I
      9 years ago

      Sorry for not responding sooner. This is exactly what I needed!

       

      Treyson