GroupKind.Type

Updated on

GroupKind.Type specifies the kind of grouping.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the GroupKind.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

ArgumentValueDescription
GroupKind.Local0A local group is formed from a consecutive sequence of rows from an input table with the same key value. That means two rows with the same value will be placed in different groups if there’s a row with a different value between them.
GroupKind.Global1A global group is formed from all rows in an input table with the same key value.

Applies to

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

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/groupkind-type