Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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])

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Create a calculated column formula to extract Date from the Date/Time column

Date = int(Data[DateTime])

Create a Calendar Table and write calculated column formulas to exteact Year, Month name and Month number.  Sort the Month name by the month number.  To your visual, drag Year and Month name from the Calendar Table and select any one Year and Month name.  Write these measures:

Phone number count = counta(Data[Phone])

Measure 1 = countrows(filter(values(Data[Phone]),[Phone number count]>1))

Hope this helps.