GroupKind.Global

Updated on

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.

Table.Group dataset

With GroupKind.Global you can group this table into groups that consider all values regardless of their order.

Table.Group with GroupKind.Global in Power Query
= Table.Group( 
    Source,
    "CustomerID",
    { "Total", each List.Sum( _[Price] ), Int64.Type },
    GroupKind.Global                                    // Specificies groupkind Global
 )

Learn more about GroupKind.Global in the following articles:

Other related enumerations are:

Applies to

Here’s a list of functions that work with GroupKind.Type:

Contribute » | Contributors: Rick de Groot