The Power BI LOWER function is one of the DAX text functions useful to convert the uppercase string characters to lowercase. This article explains the DAX LOWER function that accepts the text and returns the lowercase characters and the syntax is as shown below:
LOWER(<text>)
Power BI DAX LOWER function Example
To demonstrate the DAX LOWER() function, click the New Column button in the Modeling Tab, and name as the LowercaseName. The below expression converts the uppercase characters in a FullName column in each row to lowercase.
Next, please add the LowercaseName column to the table report. Please refer to the DAX String functions and the DAX functions article available on the Power BI tutorial page for the remaining built-in functions.
LowercaseName = LOWER(EmployeeEmails[FullName])
Similarly, we have created two more New Columns to convert the uppercase Education and Profession columns to lowercase. Please refer to the Power BI Charts article for the remaining graphs.
LowerEDU = LOWER(EmployeeEmails[Education])
LowerPro = LOWER(EmployeeEmails[Profession])
