CONCATENATE() : CONCATENATE( FirstName, " ", LastName ) : Join strings

CONCATENATEX() : CONCATENATEX( VALUES(Product[Category]), Product[Category],", ") : Concatenate
across rows

LEFT() : LEFT( Product[SKU],3 ) : Extract left characters

RIGHT() : RIGHT( Product[SKU],2 ) : Extract right characters

MID() : MID( Product[SKU],4,2 ) : Substring

LEN() : LEN( Product[Name] ) : String length

LOWER() : LOWER( Customer[Email] ) : Lowercase

UPPER() : UPPER( Customer[City] ) : Uppercase

TRIM() : TRIM( Product[Name] ) : Remove leading/trailing spaces

REPLACE() : REPLACE( Product[Name],1,5,"New" ) : Replace substring by position

SUBSTITUTE() : SUBSTITUTE( Comment,"bad","good" ) : Replace substring by match

FIND() : FIND( "@", Email, 1, 0 ) : Position of substring

SEARCH() : SEARCH( "Pro", Product[Name], 1, -1 ) : Case-insensitive find

FORMAT() : FORMAT( Sales, "#,##0.00" ) : Number/date formatting

BLANK() : BLANK() : Return blank value