Forum Discussion
Remove Duplicates - Row count
I know how to remove the duplicate rows in the Query Editor. Is there a way to know how many duplcates were present? For example, in excel when we remove duplicates, it tells us "This many duplic...
You can check all rows in power query. The top 1000 is only if the result has more than 1000. If you run "Keep duplicates" first then you can add a custom step like this to check it
= Table.RowCount(#"Keep duplicates")
Hope this helps
You can do a GROUPBY in power query and add columns for count and distinct count.