LEFT Function (DAX)

How does the LEFT function (DAX) work?

The LEFT function (DAX) returns the number of characters defined at the start of a text string.

LEFT Formula Syntax

LEFT(
     <text>, <num_chars>
)

How do you use the LEFT function?

DAX works with Unicode and all characters are stored on the same length. Thus a single LEFT function is necessary to remove the characters.

Related Blog Posts

Related Support Forum Posts

Dax formula to filter results on product codes
Dates Table Month Ordering
Can you split a text column in Power BI using DAX?

Considerations when using the LEFT function

If the argument num chars is a number that is greater than the number of characters in the text string, the function DAX LEFT returns the maximum available characters and does not create any errors.

Related Video Tutorials

Formula examples using the LEFT function

=CONCATENATE (
      (LEFT(
‘Reseller'[ResellerName],
LEFT(GeographyKey,3)
)

=CONCATENATE (
      (LEFT(
[Product], 5), [No. of Units])

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership