Forum Discussion
Remove duplicates doesn't work
Looking at your data, these rows aren't duplicates since Power Query is case-sensitive.
If you want these to be considered the same, I'd recommend adding a step to transform to all lowercase before removing duplicates.
Yes, of course. Here below the M code.
An example of user that this code can't remove is "Jvn_91" and I couldn't figure it out why.
Hmm. That's pretty odd. Any chance you can share the CSV or an edited version of it so we can try to reproduce your result?
On the off-chance this is just a caching thing, I recommend hitting Refresh Preview again.
I just tried to hit Refresh Preview, but it doesn't work. That's really strange because it always worked in the past.
Here there is the csv file (Link for the csv file - open it with Firefox because the other browers can't open it)
Looking at your data, these rows aren't duplicates since Power Query is case-sensitive.
If you want these to be considered the same, I'd recommend adding a step to transform to all lowercase before removing duplicates.
Thanks a lot, I didn't notice that the two have different initials 😅