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 articles
Learn more about LEFT in the following articles:
-
From SQL to DAX: String Comparison
In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set of features you have in SQL, a few text comparison functions in DAX are only case-sensitive and others only case-insensitive,… » Read more
Related functions
Other related functions are:
Last update: Jan 11, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/left-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies