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
