Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Power Query - Feature addition - To keep duplicates

It would be useful to have an M function to keep duplicates based on selected column(s). This would allow the users to see the user to recognise where the duplicates occur and to choose which row to keep in the Table (from the duplicates). At this moment to find the duplicates I am using GroupBy, Allrows, Count rows, Select the groups that has more than 2 in count. For large dataset that has over 500000 rows having few duplicates, this approach creates unwanted too many groups a Thus, this is not an efficient method I feel.  A Table.NonDistinct function in M may help. Is that possible?

Status: Declined

We actually have an option out of the box today. You can find it inside of the Home tab inside the "Reduce rows" group, and with the label "Keep duplicates" as shown in the screenshot below

miguel_0-1750716311042.png

 

Comments
AnetaK
Helper V
Maybe this option would be useful: View -> Data Preview -> Column profile -> You can recognize values with duplicates.
miguel
Community Admin
Status changed to: Declined

We actually have an option out of the box today. You can find it inside of the Home tab inside the "Reduce rows" group, and with the label "Keep duplicates" as shown in the screenshot below

miguel_0-1750716311042.png