GroupKind.Global (1) is an enumeration that specifies the kind of grouping. It is a member of the GroupKind.Type and specifies that a global group is formed from all rows in an input table with the same key value. In other words, GroupKind.Global considers all rows when forming groups.
Examples
Imagine having the following table in a step called Source.
With GroupKind.Global you can group this table into groups that consider all values regardless of their order.
= Table.Group(
Source,
"CustomerID",
{ "Total", each List.Sum( _[Price] ), Int64.Type },
GroupKind.Global // Specificies groupkind Global
)Related enumerations
Other related enumerations are:
Applies to
Here’s a list of functions that work with GroupKind.Type:
