GroupKind.Local (0) is an enumeration that specifies the kind of grouping. It is a member of the GroupKind.Type and specifies that a local group is formed from a consecutive sequence of rows from an input table with the same key value. In other words, two rows with the same value will be placed in different groups if there’s a row with a different value between them.
Examples
Imagine having the following table in a step called Source.
With GroupKind.Local you can group this table into groups of consecutive values, respecting the order of the data.
= Table.Group(
Source,
"CustomerID",
{ "Total", each List.Sum( _[Price] ), Int64.Type },
GroupKind.Local // Specificies groupkind Local
)Related enumerations
Other related enumerations are:
Applies to
Here’s a list of functions that work with GroupKind.Type:
