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

ActiveDirectory.Domains
Returns a table of Active Directory domains accessible from the current machine or from a specified domain controller.
AnalysisServices.Database
Returns a navigation table of cubes and tables from an Analysis Services or Azure Analysis Services database.
AzureStorage.Blobs
Returns a navigation table of containers and blobs from an Azure Blob Storage account.
AzureStorage.Tables
Returns a navigation table of Azure Table Storage tables from the specified storage account.
Binary.From
Converts a value to its binary representation.
Binary.FromText
Decodes text encoded as Base64 or hexadecimal into a binary value.
Accessing Data
Functions for connecting to and reading from data sources.
30 functions
Binary
Functions for working with binary data.
4 functions
Combiner
Functions that combine multiple values into a single value.
5 functions
Comparer
Functions for comparing values with customizable comparison logic.
4 functions
Date
Functions for creating, manipulating, and extracting parts of date values.
58 functions
DateTime
Functions for working with combined date and time values.
26 functions
DateTimeZone
Functions for date/time values with timezone information.
16 functions
Duration
Functions for working with time duration values.
13 functions
Expression
Functions for evaluating and working with expressions.
1 function
Function
Functions for working with function values.
2 functions
Lines
Functions for converting text to and from lists of lines.
4 functions
List
Functions for creating, manipulating, and transforming lists.
70 functions
Logical
Functions for logical (boolean) operations.
3 functions
Number
Functions for numeric calculations, conversions, and formatting.
52 functions
Record
Functions for creating, accessing, and transforming records.
17 functions
Replacer
Functions used as replacer arguments in other functions.
2 functions
Splitter
Functions used to split text values.
10 functions
Table
Functions for creating, transforming, and querying tables.
102 functions
Text
Functions for working with text (string) values.
43 functions
Time
Functions for creating and manipulating time values.
10 functions
Type
Functions for working with the M type system.
22 functions
URI
Functions for encoding and decoding URI components.
4 functions
Value
Functions for inspecting and comparing values of any type.
14 functions