Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Cthulhu

Why Cthulhu? Because the mental gymnastics required to figure this out nearly drove me insane. And because the exact reason you would need this measure is probably beyond the comprehension of mere mo...
Other
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

eugenm - Glad it is of use! It was a fun one to put together. For a Power Query version, your best bet would be ImkeF !

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

I call that "Nested Index"-column: https://www.youtube.com/watch?v=-3KFZaYImEY

 

Table.Group(YourTable, {"Animal"}, {{"All", each Table.AddIndexColumn(_,"Index",1,1), type table}})

 

and expand ;)

  • eugenm's avatar
    eugenm
    Icon for Helper II rankHelper II
    7 years ago

    Thank you. I will circle back, should I have any questions.

    Your help is much appreciated.