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.
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.
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.