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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership