Forum Discussion
How to count duplicates within date range as applied through slicers
In a list of DateTime, phone numbers, I need to find out dupes of phone numbers based on user applied filters/slicers against date range. For exmaple, if user selected date range from 1st Jan 202...
Anonymous , You can create a date field , use that in slicer or join it with date table and use slicer from date table
DateTime = datevalue([DateTime])
You can have measures
M1= count(Table[Phone Numbers])
Duplicate = countx(filter(values(Table[Phone Numbers]) , [M1] >1 ), [Phone Numbers])
amitchandak
Super User
Super UserAnonymous , You can create a date field , use that in slicer or join it with date table and use slicer from date table
DateTime = datevalue([DateTime])
You can have measures
M1= count(Table[Phone Numbers])
Duplicate = countx(filter(values(Table[Phone Numbers]) , [M1] >1 ), [Phone Numbers])
Unfortunatly, dupes being calculated based on entire dataset. But I wanted dupes within selected date range