Word string in Power BI

[analitika123]

Hello,

I have a case when word "name" and "name     " has the same lenght of characters even it has more white spaces in the word. Therefore it shows that both words are duplicates are same despite the different number of characters.

[V-lianl-msft]

You can remove the space character in the query editor:

[VijayP]

@analitika123 

Space also will be considered as string in Length