Forum Discussion

alexsvi's avatar
alexsvi
Regular Visitor
5 years ago

Calculated column to find first parent

Hi,   Lets say I have this : ID ParentID Name Firts parent Name 1 0 Name1 Name1 2 0 Name2 Name2 3 1 Name3 Name1 4 1 Name4 Name1 5 2 Name5 Name2 6 3 Name6 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

alexsvi , Try a new column like

coalesce(maxx(filter(table, [ID] =earlier([parent_id])),[name]),[Name])

  • alexsvi's avatar
    alexsvi
    Regular Visitor
    5 years ago

    I actually need to "go up" until I have a 0 in parent_id. I can have more than 5-6 layers in reality.

    I tried your code and it almost work, but some doesnt "climb" to the top parent