Imke Feldmann shows how to strip out duplicate characters from strings in Power BI:
Function Text.RemoveRepeatingCharacters
How to use
It takes 2 arguments: The Text/string and the Delimiter. So for our example you have to enter a space, but you can use any sign there for other use cases as well.
Click through for a quick demo.