Forum Discussion

smpa01's avatar
smpa01
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's avatar
    AlexisOlson
    3 years ago

    Try this as a calculated column:

    position = 
MINX (
    FILTER (
        GENERATESERIES ( 1, PATHLENGTH ( [pathString] ) ),
        PATHITEM ( [pathString], [Value] ) = [individualValue]
    ),
    [Value]
)
jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

smpa01 

If the length of the string you are looking for is always the same can you do it mathematically?

Position = 
VAR _Search = SEARCH('Table'[individiualValue],'Table'[pathString],1,BLANK())
RETURN IF ( NOT ISBLANK ( _Search ), ( _Search - 1 ) / 5 + 1 )