LEFT DAX Function (Text)
Returns the specified number of characters from the start of a text string.
Syntax
LEFT ( <Text> [, <NumberOfCharacters>] )
| Parameter | Attributes | Description |
|---|---|---|
| Text |
The text string containing the characters you want to extract. |
|
| NumberOfCharacters | Optional |
The number of characters you want LEFT to extract; if omitted, 1. |
Return values
Scalar A single string value.
A text string.
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/left-function-dax