PowerPivot: DAX: Text Functions

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

Read more about the following text functions:

• BLANK
• CONCATENATE
• EXACT
• FIND
• FIXED
• FORMAT
• LEFT
• LEN
• LOWER
• MID
• REPLACE
• REPT
• RIGHT
• SEARCH
• SUBSTITUTE
• TRIM
• UPPER
• VALUE

Original article (before wiki edits) was written by Jeannine Takaki and JuanPablo Jofre and formatted by Mary Browning, Microsoft SQL Server Technical Writers.