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.


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( 
    { "Total", each List.Sum( _[Price] ), Int64.Type },
    GroupKind.Global                                    // Specificies groupkind Global

Other related enumerations are:

Applies to

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

BI Gorilla Blog

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.