Returns the specified number of characters from the start of a text string. Its come under Text function Dax category.
LEFT(<Text> , <NumberOfCharacters> )
|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:
Step-2: Create New column, right click on Dataset & click on 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.
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: