Text functions

Data Analysis Expressions (DAX) includes a set of text functions based on the library of string functions in Excel, but which have been modified to work with tables and columns in tabular models. This section describes text functions available in the DAX language.

In this section

BLANK

CODE

CONCATENATE

CONCATENATEX

EXACT

FIND

FIXED

FORMAT

LEFT

LEN

LOWER

MID

REPLACE

REPT

RIGHT

SEARCH

SUBSTITUTE

TRIM

UNICHAR

UPPER

VALUE