TRIM DAX Function

The TRIM function removes all spaces from text except for single spaces between words.

DAX Syntax TRIM(text-to-trim)

The parameter text-to-trim specifies the text from which we wan spaces removed, or a column that contains text.

Example: The following formula creates a new string that does not have trailing white space.

DAX

 Measure = TRIM("1This is my     City I     Love     mycity     .")