Returns the specified number of characters from the end of a text string. Its comes under Text function Dax category.
Syntax:
RIGHT(<Text> , <NumberOfCharacters> )
Description:
| S no. | 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 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 RIGHT DAX Function with one parameter, it returns 1 character from right side.
Right_Default = RIGHT(Orders[Product Sub-Category])
Step-4: Create one more column & write RIGHT DAX Function with two parameter, it returns 5 character from right side.
Right_With_Position = RIGHT(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: