Check for repeats within a time frame

[SuzanneSte]

Hello,

can you advise me on this.   This is doing what I need it to do. However I now need to add in an additional filter that will not count a repeat invitee email as a duplicate if the associated date field 'events-export'[Event Created Date], is more than 3 months ago

Would appreciate the help 🙂 

RepEmailCol =

//Check_Duplicate

VAR currentvalue='events-export'[Invitee Email]

VAR count_filtering =

    COUNTROWS(

        FILTER(

            'events-export', 'events-export'[Invitee Email]=currentvalue)     

    )      

  VAR Result =

       IF(

           count_filtering >1, "Duplicate", "Distinct"

       )

       RETURN Result

[MFelix · Accepted solution]

Hi @SuzanneSte ,

Try to change you metric to:

RepEmailCol =
//Check_Duplicate
VAR currentvalue = 'events-export'[Invitee Email]
VAR count_filtering =
    COUNTROWS (
        FILTER (
            'events-export',
            'events-export'[Invitee Email] = currentvalue
                && 'events-export'[Event Created Date]
                    >= TODAY () - 90
        )
    )
VAR Result =
    IF ( count_filtering > 1, "Duplicate", "Distinct" )
RETURN
    Result

This will be based on current date but you can change this to be picked from a slicer or something similar.

[SuzanneSte]

Thank you so much 🙂