Space between string concatenation in Power BI

[Analitika]

Hello,

I would like to ask why it happens if space appears while concatenating two strings in power bi, making separate column in table.

Here I uploaded a picture, you see a space between Komtus and $ATS.ĮPL. How to resolve this issue? Trim, clean column didn't help.

[Anonymous · Accepted solution]

Hi @Analitika ,

You can refer the following links to "remove" the spaces in Power Query Editor by Replace Values feature...

= Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"Column1"})

How to remove blank spaces with Power Query

Power Query – A function to remove spaces within Text values

Best Regards

[Hariharan_R]

Hi

What is the syntex you used? have you tried like below?

Thanks

Hari