Forum Discussion

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...

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

New Member

4 years ago

Hi Anonymous

If your data is in the below format

You can extract the date column in power query as follows(You can achieve this using DAX formula too)

Select Date Time column -> go to Add Column ribbon -> Date -> Date Only

In Power BI desktop create a measure as follows

It will return the number of times a phone number is duplicated for the selected date range.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous

Not applicable

4 years ago

Unfortunatly, its showing just a [Total Count of Phone]-1, but I wanted to know number of dupes within slicers applied

Related content