Power Query M Function Categories

Power Query M language is a powerful data mashup tool with a wide variety of functions at its disposal. These functions, totaling over 700, are organized into numerous categories, facilitating ease of access and usage. This reference guide provides an overview of the different function categories, aiming to clarify their purpose and potential applications.

Functions by Category

Accessing Data FunctionsAccessing data functions connect to data sources and return table values.
Binary FunctionsBinary functions manage binary data, enabling encoding, decoding, compression, decompression etc.
Combiner FunctionsCombiner functions enable the merging of values or records, following a pattern or condition.
Comparer FunctionsComparer functions compare values and determine sorting within datasets.
Date FunctionsDate functions extract and manipulate date values.
DateTime FunctionsDateTime functions extract and manipulate DateTime values.
DateTimeZone FunctionsDateTimeZone functions extract and manipulate DateTimeZone values.
Duration FunctionsDuration functions create and manipulate duration values.
Error Handling FunctionsError handling functions manage errors and enable error messages.
Expression FunctionsExpression functions allow the evaluation and composition of M expressions.
Function ValuesFunction values create and invoke other M functions.
Lines FunctionsLines functions convert lists of text to and from binary and single text values.
List FunctionsList functions create, manipulate and query list values.
Logical FunctionsLogical functions create and manipulate boolean (true/false) values.
Number FunctionsNumber functions handle numerical data with arithmetic, rounding, comparisons, and trigonometry.
Record FunctionsRecord functions support creating, accessing, and altering records.
Replacer FunctionsReplacer functions are used by other functions for the replacement of values.
Splitter FunctionsSplitter functions help break data into smaller parts using specific criteria.
Table FunctionsTable functions help creating, querying, and manipulating table values.
Text FunctionsText functions create and manipulate text values.
Time FunctionsTime functions help in creating and manipulating time values.
Type FunctionsType functions help in creating and manipulating type values.
Uri FunctionsUri functions enable creation and manipulation and parsing of Uniform Resource Identifiers (URIs) query strings.
Value FunctionsValue functions evaluate and perform operations on values.

Other Overviews

BI Gorilla Youtube Channel

Last update: August 13, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.