Forum Discussion
Solved
Displaying rows with a duplicate same-column value
Hey all, Relatively new to PBID, and unfamiliar with backend DAX queries. I'm probably overlooking something, as it seems this should be simple. I have a table structured as below: Row ...
Hi There,
You can use powerquery for such tasks. To identify all the rows with duplicate unique IDs,
You should perform these steps in order,
1. In PowerQuery Mode, Perform Group by operatio. This is under the Transform Tab.
In Group By, Follow the steps shown in screen shot.Group ByFilter out all the records in duplicate records column with Value 1Expand the Oppty column by clicking on the two sided arrowsRemove duplicate records and unique IDs column and rename the headers
Thanks & Regards,
Bhavesh
Hello from 2025!
Did anyone find solution to this problem? I want to show all the data (even if rows are duplicate) and the above solution is not working.