Forum Discussion

rdiazjimenez's avatar
rdiazjimenez
Frequent Visitor
6 years ago
Solved

Add index to hierarchy leves for later sorting

Hi, Using: Excel Power Query (Win64O365)   I'm trying to sort pivot table items based on their current position with a dynamically built hierarchy.   Currently using the code generously provid...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi rdiazjimenez 

    Agree with dax  , don't understand the requirement from 2)

     

    Technically, you could limit the number of levels in the fnAllParents step by adding a limit on the Level in the List.Generate function:

     

    each Table.RowCount([Result]) > 0

     

    each Table.RowCount([Result]) > 0 and Level <= YourMaxLevel

  • rdiazjimenez's avatar
    rdiazjimenez
    6 years ago

    Thank you both ImkeF and dax ,

     

    I tried at that line, but missed that the one that I had to limit was [Level] and not Table.RowCount([Result])

     

    so Imke's solution was correct by adding the surrounding brackets.

     

    each Table.RowCount([Result]) > 0 and [Level] <= YourMaxLevel

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi rdiazjimenez 

Agree with dax  , don't understand the requirement from 2)

 

Technically, you could limit the number of levels in the fnAllParents step by adding a limit on the Level in the List.Generate function:

 

each Table.RowCount([Result]) > 0

 

each Table.RowCount([Result]) > 0 and Level <= YourMaxLevel

rdiazjimenez's avatar
rdiazjimenez
Frequent Visitor
6 years ago

Thank you both ImkeF and dax ,

 

I tried at that line, but missed that the one that I had to limit was [Level] and not Table.RowCount([Result])

 

so Imke's solution was correct by adding the surrounding brackets.

 

each Table.RowCount([Result]) > 0 and [Level] <= YourMaxLevel

 

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Great to hear rdiazjimenez  ! Please mark the answers then.

    Thanks.

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi rdiazjimenez,

    It seems that you solve this problem, right?If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

    Best Regards,
    Zoe Zhi

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