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

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.