Home » DAX » DAX – RIGHT Function

DAX – RIGHT Function

RIGHT DAX Functions

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

Sample Dataset for DAX String Functions



Step-2: Create New column, right click on Dataset & click on New column.

Create 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.

Right DAX Function Example

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:

LEFT

LOWER

UPPER

ALLEXCEPT

UNION

DATATABLE

ALLSELECTED

ALL

ADDCOLUMNS

Leave a Reply