Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

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 (DAX)

CONCATENATE Function (DAX)

EXACT Function (DAX)

FIND Function (DAX)

FIXED Function (DAX)

FORMAT Function (DAX)

  • Pre-Defined Numeric Formats for the FORMAT Function (DAX)

  • Custom Numeric Formats for the FORMAT Function (DAX)

  • Pre-defined Date and Time Formats for the FORMAT Function (DAX)

  • Custom Date and Time Formats for the FORMAT Function (DAX)

LEFT Function (DAX)

LEN Function (DAX)

LOWER Function (DAX)

MID Function (DAX)

REPLACE Function (DAX)

REPT Function (DAX)

RIGHT Function (DAX)

SEARCH Function (DAX)

SUBSTITUTE Function (DAX)

TRIM Function (DAX)

UPPER Function (DAX)

VALUE Function (DAX)

See Also

Other Resources

DAX Function Reference for PowerPivot

Date and Time Functions (DAX)

Filter Functions (DAX)

Information Functions (DAX)

Logical Functions (DAX)

Math and Trigonometric Functions (DAX)

Statistical Functions (DAX)

Time Intelligence Functions (DAX)


Additional resources


  • Last updated on 2011-05-23

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026