PQM.guide
Community-driven Power Query M language reference with visual table examples. No more Table.FromRecords.
Accessing Data
Functions for connecting to and reading from data sources.
6 functions
Binary
Functions for working with binary data.
3 functions
Combiner
Functions that combine multiple values into a single value.
3 functions
Comparer
Functions for comparing values with customizable comparison logic.
3 functions
Date
Functions for creating, manipulating, and extracting parts of date values.
12 functions
DateTime
Functions for working with combined date and time values.
5 functions
DateTimeZone
Functions for date/time values with timezone information.
4 functions
Duration
Functions for working with time duration values.
7 functions
Error Handling
Functions for handling and recovering from errors.
Expression
Functions for evaluating and working with expressions.
1 function
Function
Functions for working with function values.
2 functions
Lines
Functions for converting text to and from lists of lines.
2 functions
List
Functions for creating, manipulating, and transforming lists.
15 functions
Logical
Functions for logical (boolean) operations.
3 functions
Number
Functions for numeric calculations, conversions, and formatting.
10 functions
Record
Functions for creating, accessing, and transforming records.
8 functions
Replacer
Functions used as replacer arguments in other functions.
2 functions
Splitter
Functions used to split text values.
4 functions
Table
Functions for creating, transforming, and querying tables.
39 functions
Text
Functions for working with text (string) values.
15 functions
Time
Functions for creating and manipulating time values.
5 functions
Type
Functions for working with the M type system.
4 functions
URI
Functions for encoding and decoding URI components.
3 functions
Value
Functions for inspecting and comparing values of any type.
5 functions