RIGHT Function (DAX)

How does the RIGHT function (DAX) work?

The RIGHT function (DAX) returns the last character or characters in a text string, based on the number of characters you specify.

RIGHT Formula Syntax

RIGHT (
     <text>, <num_chars>
)

How do you use the RIGHT function?

The RIGHT function can be used to counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode.

Related Blog Posts

Related Support Forum Posts

Slicer to slide right or left to show variance above a threshold
Disable other options during right click while drilling through a bar chart?
Table ageregations in the right column Median, in the bottom row SUM

Considerations when using the RIGHT function

  • Text (required) – the text string from which you want to extract characters.
  • Num_chars (optional) – the number of characters to extract, starting from the rightmost character.
    • If num_chars is omitted, 1 last character of the string is returned (default).
    • If num_chars is greater than the total number of characters in the string, all characters are returned.
    • If num_chars is a negative number, a Right formula returns the #VALUE! error.

Related Video Tutorials

Formula examples using the RIGHT function

=RIGHT(‘New Products'[ProductCode],2)

=RIGHT(A2, 3)

=RIGHT(A2,LEN(A2)-SEARCH(” “,A2))

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.