Forum Discussion
Displaying rows with a duplicate same-column value
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
BV displays doing it in 4 steps of Query Editor. Another approach is 4 steps of New filtered tables - in the example below each table is named: UniqueID1 thru UniqueID4
UniqueID1 is your starting table
UniqueID2 = GROUPBY(UniqueID1,
UniqueID1[ID],
"DupeCount",COUNTX(CURRENTGROUP(),UniqueID1[ID]))
UniqueID3 = FILTER(UniqueID2,UniqueID2[DupeCount]>1)
at this point you then must create a join line between UniqueID1.ID and UniqueID3.ID fields
UniqueID4 = FILTER(UniqueID1,UniqueID1[ID]=RELATED(UniqueID3[UniqueID1_ID]))
UniqueID4 is your final table with the results you seek
Should be simple!! but is not........
hi,
the subject is old:)
I want to delete duplicate rows but keep one rows each time .t
for example i have the left table and i want the right table. is it possible?
| unic id | time | unic id | time | |||
| 12 | 20 | 12 | 20 | |||
| 13 | 15 | 13 | 15 | |||
| 14 | 14 | 14 | 10 | |||
| 13 | 15 | |||||