Forum Discussion
Treyson
Advocate I
Advocate IFiltering 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 ra...
MFelix
Super User
Super UserHi 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
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
TreysonSorry for not responding sooner. This is exactly what I needed!
Treyson