TRIM Removes all spaces from text except for single spaces between words.
Syntax
TRIM(text)
Parameters
text – The text from which you want spaces removed, or a column that contains text.
Return Value
The string with spaces removed.
Reference Data
https://docs.microsoft.com/en-us/dax/dax-function-reference