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:
[ Ссылка ]

Functions Used
List.Range
List.Sum
Number.From
Table.AddIndexColumn
Table.Transpose
Table.Group

Using Parameters Table.

свернуть