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