Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need help to remove duplicates data that are within 12 hrs time frame if 3 columns match ID, Step, and Yes_No.
Yes_No column has 2 values "Y" and "N". Only want to remove duplicate with "Y" in this column.
Date | ID | Step | Yes_No |
7/22/19 9:00 AM | 12345 | ABCD | Y |
7/22/19 1:00 PM | 12345 | ABCD | Y |
7/22/19 3:00 PM | 12345 | ABCD | Y |
7/23/19 12:00 PM | 12345 | ABCD | Y |
Trying to remove red color text rows. Can someone help me?
Solved! Go to Solution.
Hi @EZiamslow
Please check below measures in attached file.Use the measure in visual level filter to filter the visual.
Min_date = CALCULATE(MIN(Data[Hour]),FILTER(ALLEXCEPT(Data,Data[ID],Data[Step]),Data[Date.1]=MAX(Data[Date.1])))
Measure = var _count =CALCULATE(COUNT(Data[Date]),ALLEXCEPT(Data,Data[ID],Data[Step])) return IF(_count>1&&MAX(Data[Hour])>[Min_date]&&MAX(Data[Hour])<[Min_date]+12&&MAX(Data[Yes_No])="Y",1)
Regards,
Hi @EZiamslow
Please check below measures in attached file.Use the measure in visual level filter to filter the visual.
Min_date = CALCULATE(MIN(Data[Hour]),FILTER(ALLEXCEPT(Data,Data[ID],Data[Step]),Data[Date.1]=MAX(Data[Date.1])))
Measure = var _count =CALCULATE(COUNT(Data[Date]),ALLEXCEPT(Data,Data[ID],Data[Step])) return IF(_count>1&&MAX(Data[Hour])>[Min_date]&&MAX(Data[Hour])<[Min_date]+12&&MAX(Data[Yes_No])="Y",1)
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |