Text Functions (DAX)

Data Analysis Expressions (DAX) includes a set of text functions that is based on the library of string functions in Excel, but which has been modified to work with tables and columns. This section lists all text functions available in the DAX language.

In This Section

BLANK Function

CONCATENATE Function

EXACT Function

FIND Function

FIXED Function

FORMAT Function

• Pre-Defined Numeric Formats for the FORMAT Function

• Custom Numeric Formats for the FORMAT Function

• Pre-defined Date and Time formats for the FORMAT Function

• Custom Date and Time formats for the FORMAT Function

LEFT Function

LEN Function

LOWER Function

MID Function

REPLACE Function

REPT Function

RIGHT Function

SEARCH Function

SUBSTITUTE Function

TRIM Function

UPPER Function

VALUE Function

See Also

Other Resources

DAX Function Reference

Date and Time Functions (DAX)

Filter Functions (DAX)

Information Functions (DAX)

Logical Functions (DAX)

Math and Trig Functions (DAX)

Statistical Functions (DAX)

Time Intelligence Functions (DAX)