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:
github.com/jbo...
Functions Used
List.Range
List.Sum
Number.From
Table.AddIndexColumn
Table.Transpose
Table.Group
Using Parameters Table.