PQM.guide

Community-driven Power Query M language reference with visual table examples. No more Table.FromRecords.

New to M? Start Here →

An 8-step learning path from the M paradigm to query folding.

Search 512 functions

Press Ctrl+K to search by name or description.

Recently Added

Creates a binary value from a list of byte values or a base-64 encoded text string.

Creates a date value from year, month, and day components.

Creates a datetime value from year, month, day, hour, minute, and second components.

Creates a datetimezone value from date, time, and UTC offset components.

Creates a duration value from days, hours, minutes, and seconds components.

Creates a table literal from column names and a list of row value lists.

Functions for connecting to and reading from data sources.

Functions for working with binary data.

Functions that combine multiple values into a single value.

Functions for comparing values with customizable comparison logic.

Functions for creating, manipulating, and extracting parts of date values.

Functions for working with combined date and time values.

Functions for date/time values with timezone information.

Functions for working with time duration values.

Functions for evaluating and working with expressions.

Functions for working with function values.

Functions for converting text to and from lists of lines.

Functions for creating, manipulating, and transforming lists.

Functions for logical (boolean) operations.

Functions for numeric calculations, conversions, and formatting.

Functions for creating, accessing, and transforming records.

Functions used as replacer arguments in other functions.

Functions used to split text values.

Functions for creating, transforming, and querying tables.

Functions for working with text (string) values.

Functions for creating and manipulating time values.

Functions for working with the M type system.

Functions for encoding and decoding URI components.

Functions for inspecting and comparing values of any type.