Is possible to remove duplicates in Power BI based on a time interval between the data?

Question

I have a list of data,and some of them are duplicates and I want to remove the duplicates,But the problem is the email or mobile numbers appears in more than one row in an interval of 30 days,So is there any way to remove duplicates in a time interval??

Answer 1

Use the following measures:

Day Difference = 
        VAR name1 = 'Table'[Name]
        VAR Lastdate1 = MAXX(FILTER('Table','Table'[Name]=name1 && 'Table'[date]<EARLIER('Table'[date])),'Table'[date]) 
RETURN 
        IF(
            DATEDIFF(Lastdate1,'Table'[date],DAY)=BLANK(),
            100,
            DATEDIFF(Lastdate1,'Table'[date],DAY))

Tag = 
        VAR name1 = 'Table'[Name]
        VAR Lastdate1 = MAXX(FILTER('Table','Table'[Name]=name1 && 'Table'[date]<EARLIER('Table'[date])),'Table'[date]) 
RETURN 
        IF(IF(
            DATEDIFF(Lastdate1,'Table'[date],DAY)=BLANK(),
            100, 

            DATEDIFF(Lastdate1,'Table'[date],DAY))<=30,"Duplicate","Single") 

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification