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
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
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
[Product], 5), [No. of Units])
Related DAX Functions
Related Course Modules
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.