topic Re: Trim in the word in Power BI in Developer

Trim in the word in Power BI

Analitika — Fri, 05 Nov 2021 16:03:25 GMT

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?

Re: Trim in the word in Power BI

Greg_Deckler — Fri, 05 Nov 2021 16:16:52 GMT

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

Re: Trim in the word in Power BI

Anonymous — Wed, 17 Nov 2021 06:24:02 GMT

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

Re: Trim in the word in Power BI

VijayP — Tue, 09 Nov 2021 10:46:11 GMT

@Analitika

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