Power Query - Create a Dynamic Grouping Index 🦒🩺

In this rather esoteric situation i show you how to use the 5th argument (comparer) of Table.Group to dynamically add a Grouping index column based on a sum of rows. #excel #dataquerying #powerquery #mquery #powerbi #tutorial #dataanalysis Follow along file: https://github.com/jbotes/powerbiTutorials/blob/main/PQ_Grouping_Video_2.xlsx Functions Used List.Range List.Sum Number.From Table.AddIndexColumn Table.Transpose Table.Group Using Parameters Table.