Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating a Parent-Child Hierarchy

I have a data set that looks like the following: ID Name Manager 1 Adam John 2 John     I want there to be another column called 'Manager ID' that obtains the ID of each person's...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

    I'm not sure if you want calculated column or measure, so both are created.

    In addition, [__Maganer] is a necessary condition for calculation. Although you don't need it, the final result can not be obtained without it.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Greg_Deckler

     

    I've tried LOOKUPVALUE but that doesn't seem to achieve what I required - unless I am using it incorrectly?

     

    In terms of the concentrated column, would that be ID|Display Name to use PATH to pull the ID of each person's manager?

     

    Thanks