Quick reference

 

Updated: July 18, 2015

The following table is a quick reference to Power Query Formula Language (informally known as "M").

Formula expression Evaluated (computed) to yield a value. An M value can be a List, Record, Table, or scalar value.
Primitive value A single-part value of type:

Text

Number

Time

Date

DateTime

DateTimeZone

Duration

Binary

Logical

Null
List An ordered sequence of values. For example: {1, 2, 3}
Record A Record is a set of fields. A field is a name/value pair where the name is a text value that is unique within the field’s record. For example: [CustomerID = 1, Name = "Bob"]
Table A Table is a set of values organized into named columns and rows. For example: #table( {"OrderID", "CustomerID", "Item", "Price"}, { {1, 1, "Fishing rod", 100.00}, {2, 1, "1 lb. worms", 5.00} })
Function value A Function is a value which, when invoked with arguments, produces a new value.

For Example: (x, y) => x + y or each Text.From([CustomerID])
Let expression The let expression allows a set of values to be computed, assigned names, and then used in a subsequent expression that follows the in.
Power Query (informally known as "M") Formula reference M includes a common set of definitions available for use from an expression called the standard library (library).
Operators M supports common Operators including >, >=, <, <=, =, <>, or, and, not, +, -, *, /, &.
Type conversion The M language has formulas to convert between types.
Metadata Metadata is information about a value that is associated with a value.
Errors An error is an indication that the process of evaluating an expression could not produce a value.