Forum Discussion
Remove duplicates not working in Power Query?
I am simply trying to remove duplicates in a column. I have done this many times with no problems, but this time it is leaving one duplicate.
I originally had several thousand rows of data in the table, now I am down to 131. However, it clearly says that there are 130 distinct values.
Can anyone explain why this is not working properly?
markmess77 you should drop territory and count of territory and table visual and see which territory has a count of two and then you can take a look at data what is causing it. maybe there is a special character/non-visible character
2 Replies
markmess77 you should drop territory and count of territory and table visual and see which territory has a count of two and then you can take a look at data what is causing it. maybe there is a special character/non-visible character
