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

     

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

Hi rdiazjimenez,

According to your code sample, it seems that you have solved your part of your problem. But I don't understand your requirement.

If possible, could you please explain " Limit the number of levels calculated to a certain number (in order to not beak hierarchy in PowerPivot) (if possible)" to me?

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.

 

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.