Functions
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.
Function Categories
| Category | Description |
|---|---|
| Access Data | Access Data functions for Power Query M language. |
| Binary functions | Binary functions functions for Power Query M language. |
| Combiner functions | Combiner functions functions for Power Query M language. |
| Comparer functions | Comparer functions functions for Power Query M language. |
| Date and time functions | Date and time functions functions for Power Query M language. |
| Date functions | Date functions functions for Power Query M language. |
| DateTimeZone functions | DateTimeZone functions functions for Power Query M language. |
| Duration functions | Duration functions functions for Power Query M language. |
| Error functions | Error functions functions for Power Query M language. |
| Expression functions | Expression functions functions for Power Query M language. |
| Function values | Function values functions for Power Query M language. |
| Lines functions | Lines functions functions for Power Query M language. |
| List functions | List functions functions for Power Query M language. |
| Logical functions | Logical functions functions for Power Query M language. |
| Number functions | Number functions functions for Power Query M language. |
| Record functions | Record functions functions for Power Query M language. |
| Replacer functions | Replacer functions functions for Power Query M language. |
| Splitter functions | Splitter functions functions for Power Query M language. |
| Table functions | Table functions functions for Power Query M language. |
| Text functions | Text functions functions for Power Query M language. |
| Time functions | Time functions functions for Power Query M language. |
| Type functions | Type functions functions for Power Query M language. |
| Uri functions | Uri functions functions for Power Query M language. |
| Value functions | Value functions functions for Power Query M language. |