How do I check duplicates by Applying 90 day logic and publishing first touch month

[vanik85]

I have a table with below fileds

Month	Mobile	UTM
10-Apr	11111	Organic
12-Apr	11111	Paid
15-Apr	22222	Paid
20-Apr	33333	Paid
02-May	55555	Paid
12-May	33333	Organic
12-May	22222	Organic
12-Jun	11111	Web
12-Jun	44444	Paid
28-Jul	22222	Paid

I wish to check duplicates in mobile numbers by checking past 90 days and accordinlgy revert with Unique or Repeat user. Additonally need to mention first touch points

Month	Mobile	UTM	Unique/Repeat	First Touch Month	First Touch UTM
10-Apr	11111	Organic	Repeat	Apr	Organic
12-Apr	11111	Paid	Repeat	Apr	Organic
15-Apr	22222	Paid	Repeat	Apr	Paid
20-Apr	33333	Paid	Repeat	Apr	Paid
02-May	55555	Paid	Unique	May	Paid
12-May	33333	Organic	Repeat	Apr	Paid
12-May	22222	Organic	Repeat	Apr	Paid
12-Jun	11111	Web	Repeat	Apr	Organic
12-Jun	44444	Paid	Unique	June	Paid
28-Jul	22222	Paid	Unique	July	Paid

[Anonymous]

Hi @vanik85 ,

Please have a  try.

Create a measure.

measure =
VAR _1 =
    CALCULATE (
        MIN ( table[month] ),
        FILTER ( ALL ( table ), table[mobile] = SELECTEDVALUE ( table[mobile] ) )
    )
RETURN
    IF ( MAX ( table[month] ) = _1, MAX ( table[UTM] ), BLANK () )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[vanik85]

tried depicting ask with the help of flow diagram 

[tamerj1]

Hi @vanik85 
Please clearly define past 90 days with examples.

[vanik85]

Tried depicting ask with the help of flow diagram