Share via


Enumerations

The Power Query M formula language includes these enumerations.

List of enumerations

Name Description
AccessControlKind.Type Specifies the kind of access control.
BinaryEncoding.Type Specifies the type of binary encoding.
BinaryOccurrence.Type Specifies how many times the item is expected to appear in the group.
BufferMode.Type Describes the type of buffering to be performed.
ByteOrder.Type Specifies the byte order.
Compression.Type Specifies the type of compression.
CsvStyle.Type Specifies the significance of quotes in a CSV document.
Day.Type Represents the day of the week.
ExtraValues.Type Specifies the expected action for extra values in a row that contains columns less than expected.
GroupKind.Type Specifies the kind of grouping.
JoinAlgorithm.Type Specifies the join algorithm to be used in the join operation.
JoinKind.Type Specifies the kind of join operation.
JoinSide.Type Specifies the left or right table of a join.
LimitClauseKind.Type Indicates the features that the specific SQL dialect supports.
MissingField.Type Specifies the expected action for missing values in a row that contains columns less than expected.
Occurrence.Type Specifies the occurrence of an element in a sequence.
ODataOmitValues.Type Specifies the kinds of values an OData service can omit.
Order.Type Specifies the direction of sorting.
PercentileMode.Type Specifies the percentile mode type.
Precision.Type Specifies the precision of comparison.
QuoteStyle.Type Specifies the quote style.
RankKind.Type Specifies the precise ranking method.
RelativePosition.Type Indicates whether indexing should be done from the start or end of the input.
RoundingMode.Type Specifies rounding direction when there is a tie between the possible numbers to round to.
SapBusinessWarehouseExecutionMode.Type Specifies valid options for SAP Business Warehouse execution mode option.
SapHanaDistribution.Type Specifies valid options for SAP HANA distribution option.
SapHanaRangeOperator.Type Specifies a range operator for SAP HANA range input parameters.
TextEncoding.Type Specifies the text encoding type.
TraceLevel.Type Specifies the trace level.
WebMethod.Type Specifies an HTTP method.