Forum Discussion
Power Query not removing all duplicates
Hi andrew_sxs - I would like to suggest that you Filter you population in Power Query before the remove Duplicates step. If possible include an example where there are:
- no duplicates to remove
- duplicate has been removed successfully
- duplicate is not removed
This will help you visible see what is happening. It is possible that you need Trim or change case on the column with the duplicates because the following are not the same: "ABC" <> "AbC" or "ABC ".
Did you remove duplicates on the whole table or only on a single column? The reason I ask is that it looks like the rows are probably unique even if there are duplicates in the first column.
What does the M code for the remove duplicates step look like?
M code is as follows - So I presume it is meant to be removing all duplicates within this column, despite the fact that other columns have differing information which would make the whole row distinct but not the column?
Remaining duplicate values (9 in total) in this column are as follows:
why did you distinct the table depending on the column of description, and then count the distinct values of item code?
maybe there some item codes have two descriptions.
