PATHITEMREVERSE Returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted backwards from right to left.


PATHITEMREVERSE(path, position[, type])


path – A text string in the form of the results of a PATH function.

position – An integer expression with the position of the item to be returned.

type – (Optional)An enumeration that defines the data type of the result:

TEXT 0 – Results are returned with the data type of text. (default)
INTEGER 1 – Results are returned with the data type of integer.

Return Value

The n-position ascendant in the given path, counting from current to the oldest.

Reference Data

DAX Functions / Parent and Child Functions / PATHITEMREVERSE