LOWER function DAX

LOWER function is a Power BI text functions which converts a text string to all lowercase letters.

SYNTAX

LOWER (<text>)

text is the text you want converted to lowercase, or a reference to a column that contains text.





Lets look at an example of using LOWER function in Power BI.

Here we have a sample data named Employee as shown below.

Copy Sample data:
Name Code
PRADEEP SINGH XVSD-032
Sushant Agarwal VFSG-57
MANDEEP SINGH GYSe-36
Rhoit Singh VSGs-37
SUJOY singh Fse3-35
Manoj RAWAT GSwr-23
Using LOWER Function

Assume that you want to see all employee name in lowercase, then you can use LOWER function as shown below.

Lets add a new column in table Employee.

Go to Field pane, right click on Employee dataset and select new column from context menu.

Or you can also add new column using different way, go to Data view page, and click on New column inside Table Tools tab.

Now write following DAX, which uses LOWER function and returns all the name in lowercase.

CovertToLower = Lower(Employee[Name])
Once you commit the Dax, a new column is created into dataset Employee.

Now to see the output, go to data view page, there you can see all the name strings are converted into lowercase.




What happen if your string contains Non-alphabetic characters

In case when string contains Non-alphabetic characters then LOWER function does not affect them, and only coverts alphabetic characters into lowercase.

You can see Code column in Employee dataset having mix alphanumeric string means it contains mix characters such as alphabets and numeric characters.

Lets use LOWER function to converts code string into lowercase.

Again, we will add a new column in dataset as shown below.

CovertToLower_Mix = LOWER(Employee[Code])





 You can see, Code string are converted into uppercase,  and non-alphabetic characters are not affected.

Also Read..

UPPER

LEN

UNICHAR

REPT

REPLACE

SUBSTITUE

CONCATENATEX

FIND

FORMAT

MID

SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More

 126 total views,  1 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.