PATHITEMREVERSE

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.


Syntax

PATHITEMREVERSE(path, position[, type])

Parameters

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

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Parent and Child Functions / PATHITEMREVERSE