Dax Text Functions

Text Functions within Microsoft Power BI.

A. CONCATENATE: 

Full Name = CONCATENATE(Customer[First Name], " ", Customer[Last Name]) 

This example concatenates the First Name and Last Name columns in the Customer table, resulting in a single string representing the customer's full name. 

B. LEFT: 

First Initial = LEFT(Employee[Name], 1) 

This example returns the first character from the Name column in the Employee table, providing the employee's first initial. 

C. RIGHT: 

Last Two Digits = RIGHT(Sales[Invoice Number], 2)  

This example returns the last two characters from the Invoice Number column in the Sales table, extracting the last two digits. 

D. MID: 

Order Code = MID(Orders[Order Number], 3, 4) 

This example returns a substring of four characters starting from the third character of the Order Number column in the Orders table. 

E. UPPER: 

Capitalized Country = UPPER(Location[Country]) 

This example converts the Country column in the Location table to uppercase, providing the country name in capital letters. 

F. LOWER: 

Lowercase Text = LOWER(Notes[Description])  

This example converts the Description column in the Notes table to lowercase, providing the text in lowercase letters.