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.
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 😅
Actually, I don't see the difference "j" in this case. If I see my data they are both capitalized. How do you see them differently from me?
Here there is another example:
You are looking at the table in the Data pane rather than the query editor like I was.
I'm guessing the engine selected a single representation to show since DAX doesn't inherently distinguish case like M does.