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.
Hello
I am trying to filter a list for duplicate values in one column, but only when another column does not have a duplicate value.
So in my example data i would want to pull out "Ref" 112244 because there is a duplicate and the "IncidentID" is different on both "Ref".
I would not want to include "Ref" 130130" because this Ref has the same "IncidentID". Hopefully this makes sense?
How would you go about achieving this filtered list?
Thanks
Solved! Go to Solution.
You may add a calculated column.
Column = ISEMPTY ( FILTER ( 'Table', 'Table'[Ref] = EARLIER ( 'Table'[Ref] ) && 'Table'[IncidentID] <> EARLIER ( 'Table'[IncidentID] ) ) )
You may add a calculated column.
Column = ISEMPTY ( FILTER ( 'Table', 'Table'[Ref] = EARLIER ( 'Table'[Ref] ) && 'Table'[IncidentID] <> EARLIER ( 'Table'[IncidentID] ) ) )
Hi,
Just select both those columns ref & ID, and remove duplicates in PowerQuery.
You should get your desired result.
Robbe
Thanks i have used power query to de-duplicate the IncidentID field, but for the Ref field, it's the duplicates only i want to display (excluding unique records). Is this also possible in power query?
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |