Forum Discussion
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 |
|--------|------------------|---...
Try this as a calculated column:
position = MINX ( FILTER ( GENERATESERIES ( 1, PATHLENGTH ( [pathString] ) ), PATHITEM ( [pathString], [Value] ) = [individualValue] ), [Value] )
Try this as a calculated column:
position =
MINX (
FILTER (
GENERATESERIES ( 1, PATHLENGTH ( [pathString] ) ),
PATHITEM ( [pathString], [Value] ) = [individualValue]
),
[Value]
)