Find Parent of Parent with DAX

[saralsaral]

I have simple task, I need to obtain the 'Grandparent' of an item. The Parent ID is already a column in the data, just need the Granparent ID. I tried LOOKUPVALUE, but I don't know what the 3rd argument will be?

Parent_of_Parent_ID = LOOKUPVALUE('Table'[Parent ID], 'Table'[ID], )

Name	ID	Parent ID	Expected_Output (Parent of Parent)
foo	10	12	15
bar	12	15	18
baz	15	18
buzz	18

[Samarth_18 · Accepted solution]

Hi @saralsaral ,

You can try below code:-

Parent of Parent =
VAR _path =
    PATH ( 'Parent_hirarchy'[ID], Parent_hirarchy[Parent ID] )
RETURN
    PATHITEMREVERSE ( _path, 3 )

Output:-

Thanks

Samarth

[Tanushree_Kapse]

Hi @saralsaral ,

https://docs.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax

Please refer above link.

Mark this as a solution if I answered your question.

Thanks.