Skip to main content

Text Functions

Image
By

DAX includes a set of text functions based on the library of string. Text functions work with tables and columns.

DAX Text functions help us to return a part of a string, you can search & find for text within a string, concatenate string values and can perform many more operations.

Microsoft Power BI DAX provides various types of Text Functions such as:

UPPER 

LOWER

LEFT

RIGHT

CONCATENATE

CONCATENATEX 

LEN

SUBSTITUTE

Popular posts from this blog

ALL DAX function

By
As it’s name suggests, Returns all the rows in a table, or all the values in a column.  ALL function removes the applied filters from the filter context. Its comes under Filter function DAX category.
Post a Comment
Read more

LOOKUPVALUE DAX Function

By
Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions. Its comes under Filter function DAX category.
Post a Comment
Read more