Forum Discussion

witbi's avatar
witbi
Helper I
5 years ago
Solved

PATH function extract sub-level 2 hierarchy

I'm trying to use PATH functions to generate a flat table for filtering. Examples online seem to start with an explicit hierarchy in the table. I'm stuck on extracting the sub-level 2 hierarchy from ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello witbi 
    Are you looking for this?
    Yes, try this. For this, you need to add the index column.
    You can easily add the index column in the power query editor.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    witbi here is the formula for your reference

    you just need to change the number which the arrow points.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello witbi 
Are you looking for this?
Yes, try this. For this, you need to add the index column.
You can easily add the index column in the power query editor.

witbi's avatar
witbi
Helper I
5 years ago

Yes Anonymous an Index makes sense