undefined

[pabloporto]

Estou utilizando a função limpar para retirar os espaçamentos duplos entre os textos, porém essa função não está retirando os espamentos duplos. Alguém por gentileza poderia me ajudar? Desde ja, grato.

@PowerBI @PowerQuery Contenido de aprendizaje de Power BI  @comunidadepowerbi

[Anonymous · Accepted solution]

Hi @pabloporto ，

I have created a simple sample. Please refer to my pbix to see if it helps you.

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

= Table.ReplaceValue(#"Replaced Value","  ","",Replacer.ReplaceText,{"value"})

Or another way is easier.

Right-click on the column to be edited and select Replace Values.

Then replace the values.

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@pabloporto , If that is double space, then use replace option replace double space with single (or none)

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk