RIGHT RIGHT returns the last character or characters in a text string, based on the number of characters you specify.


RIGHT(text, num_chars)


text – The text string that contains the characters you want to extract, or a reference to a column that contains text.
num_chars – (optional) The number of characters you want RIGHT to extract; is omitted, 1. You can also use a reference to a column that contains numbers.

Return Value

If the column reference does not contain text, it is implicitly cast as text.

Reference Data


DAX Functions / Text Functions / RIGHT