Forum Discussion
Solved
Space between string concatenation in Power BI
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 ...
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
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