BinaryOccurrence.Type

Updated on

BinaryOccurrence.Type specifies how many times the item is expected to appear in the group.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the BinaryOccurrence.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
BinaryOccurrence.Optional0The item is expected to appear zero or one time in the input.
BinaryOccurrence.Required1The item is expected to appear once in the input.
BinaryOccurrence.Repeating2The item is expected to appear zero or more times in the input.

Applies to

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

BI Gorilla Youtube Channel

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