Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JayV
Frequent Visitor

Find duplicates between "date selected" and "date selected" - 30 days

Hi! 🙂
I have date filters (slicer) for year, month and day in a model that uses a table with [ID] and [Date]
I want to show the duplicates between the "Date selected" and ("Date selected" -30 days)
This is the table:
table.png
If i select "December 1st, 2022" it should only show these:
imagen_2022-12-09_134554652.png

Thank you!

3 REPLIES 3
JayV
Frequent Visitor

I tried using EARLIER() in a calculated column:

 

Repetitive_column =
IF (
    COUNTROWS ( FILTER ( 'Table', 'Table'[ID]  = EARLIER ( 'Table'[ID] ) ) )
        > 1,
    "YES",
    "NO"
)

 

I also tried using this measure and it almost worked (adding the Repetitive_column to the filters if "YES"); It also shows non-duplicates inside the 30d range (if it is a duplicate it shows the row that's inside the 30d range and exclude the one outside):

 

Datefilter_measure =
CALCULATE (
    COUNTROWS('Table'),
    DATESINPERIOD ( 'Table'[Date], LASTDATE ( 'Table'[Date] ), -30, DAY ) 
)

 

amitchandak
Super User
Super User

@JayV , Try meausres like this

 

Have duplicate
measure =
var _cnt = calculate(count('Table'[ID]))
return
countx(Values('Table'[ID]), if(_cnt>1, [ID], Blank()))


Have No duplicate
measure =
var _cnt = calculate(count('Table'[ID]))
return
countx(Values('Table'[ID]), if(_cnt>1, [ID], Blank()))

Excuse me, where should i use this or how could i add the -30 day filter? should i add it to my existing dax?
Thanks for the help!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors