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

Category	Description
Accessing Data	Accessing data functions connect to data sources and return table values.
Binary	Binary functions process binary data for encoding, decoding, compression, decompression, etc.
Combiner	Combiner functions merge values or records, following a pattern or condition.
Comparer	Comparer functions compare values and determine sorting within datasets.
Date	Date functions extract and manipulate date values.
DateTime	DateTime functions extract and manipulate DateTime values.
DateTimeZone	DateTimeZone functions extract and manipulate DateTimeZone values.
Duration	Duration functions create and manipulate duration values.
Error Handling	Error handling functions manage errors and enable error messages.
Expression	Expression functions allow the evaluation and composition of M expressions.
Function Values	Function values create and invoke other M functions.
Lines	Lines functions convert lists of text to and from binary and single text values.
List	List functions create, manipulate and query list values.
Logical	Logical functions create and manipulate boolean (true/false) values.
Number	Number functions perform arithmetic, rounding, comparisons, and trigonometry.
Record	Record functions support creating, accessing, and altering records.
Replacer	Replacer functions are used by other functions for the replacement of values.
Splitter	Splitter functions help break data into smaller parts using specific criteria.
Table	Table functions help creating, querying, and manipulating table values.
Text	Text functions create and manipulate text values.
Time	Time functions help in creating and manipulating time values.
Type	Type functions help in creating and manipulating type values.
Uri	Uri functions enable creation and manipulation and parsing of Uniform Resource Identifiers (URIs) query strings.
Value	Value functions evaluate and perform operations on values.

Other Overviews

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference