DAX Function Guide

Use TRIM on text that you have received from another application that may have irregular spacing.

The TRIM function does not remove the nonbreaking space character. For an example of how to trim both space characters from text, see Remove spaces and nonprinting characters from text.

If you need to remove trailing non-breaking spaces, create a computed field using the following expression. The REPLACE( ) function replaces any non-breaking spaces with regular spaces, and then TRIM( ) removes any trailing regular spaces. TRIM( ) is related to the LTRIM( ) function, which removes any leading spaces from a string, and to the ALLTRIM( ) function, which removes both leading and trailing spaces.