Trim in the word in Power BI

[Analitika]

Hello,

I would like to ask why after operation (Close and Apply) in Power BI I am getting word (one with space, other without space), like we have a word "name" but after close and apply I am getting "name" and "name "? I expected to get one word "name" not "name" and "name ". Is it possible to work around it?

[VijayP]

@Analitika 

In My experience , I just replace values if the number of replacement attributes are manageable

[Anonymous]

Hi @Analitika ,

Just as suggested by @Greg_Deckler , please deal with it in Power Query Editor using Trim and Clean option. You can check the following blog for more details on trim and clean function.

Trim Vs. Clean in Power BI and Power Query

If the above one can't help resolve your problem, please provide more details(sample data, screenshot and backend scenario etc.) on your problem. Thank you.

Best Regards

[Greg_Deckler · Accepted solution]

@Analitika Try using Clean and Trim. If the character at the end is something like a tab then trim will not remove it but clean will.