GroupKind.Local

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 articles

Learn more about GroupKind.Local 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.Global

Applies to

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

• Table.Group

Contribute » | Contributors: Rick de Groot