Returns the specified number of characters from the start of a text string. Its come under Text function Dax category.
Syntax:
LEFT(<Text> , <NumberOfCharacters> )
Description:
| SNo. | Parameter | Description |
| 1 | Text | The text string containing the characters you want to extract. |
| 2 | NumberOfCharacters | This is Optional, The number of characters you want LEFT to extract. If omitted, default is 1. |
Let’s start with an example:
Step-1: Sample Dataset as below:
Sample Dataset for DAX String Functions
Step-2: Create New column, right click on Dataset & click on New column.
Create New Column
Step-3: Now write LEFT DAX Function with one parameter, it returns 1 character from left side.
Left_Default = LEFT(Orders[Product Sub-Category])
Step-4: Create one more column & write LEFT DAX Function with two parameter, it returns 5 character from left side.
Left_With_Position = LEFT(Orders[Product Sub-Category],5)
Step-5: Drag both new columns to Table visual & see the output.
LEFT DAX Function
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended DAX Post: