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))