GroupKind.Global

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 articles

Learn more about GroupKind.Global in the following articles:

• Using Custom Comparers with Table.Group in Power Query
  This article shows you how to use the Comparer Function in Table.Group. You’ll also learn how to create a custom comparer function for more precise data grouping. » Read more

Related enumerations

Other related enumerations are:

• GroupKind.Local

Applies to

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

• Table.Group

Contribute » | Contributors: Rick de Groot