Forum Discussion

Community Champion

3 years ago

Solved

Path reverse lookup

Is there any way to achieve a reverse look up that returns the memeber position on the path? I have this | rowNum | pathString | individiualValue | |--------|------------------|---...

Need Help

AlexisOlson

3 years ago

Try this as a calculated column:

position = 
MINX (
    FILTER (
        GENERATESERIES ( 1, PATHLENGTH ( [pathString] ) ),
        PATHITEM ( [pathString], [Value] ) = [individualValue]
    ),
    [Value]
)