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.

     

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

witbi here is the formula for your reference

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

 

  • witbi's avatar
    witbi
    Helper I
    5 years ago

    Wow, many thanks again wdx223_Daniel. This works! I have learned much from your clear and elegant solutions.