LOWER DAX Function in Power BI
The LOWER DAX function converts all letters in a text string to lowercase.
DAX Syntax LOWER(text)
The function parameter text specifies the text we want to convert to lowercase, or a reference to a column that contains text.
Example: Let’s create a calculate column in the Students table.
The following dax formula gets each row in the column, [Name], and converts the value to all lowercase. Numbers in the column are not affected.
DAX
Lowercase name = LOWER(Students[Name])
The output of the dax function is shown below:
