Power Query M function reference

The Power Query M function reference includes articles for each of the over 700 functions. These reference articles are auto-generated from in-product help. To learn more about functions and how they work in an expression, go to Understanding Power Query M functions.

Functions by category

• Accessing data functions
• Binary functions
• Combiner functions
• Comparer functions
• Date functions
• DateTime functions
• DateTimeZone functions
• Duration functions
• Error handling
• Expression functions
• Function values
• List functions
• Lines functions
• Logical functions
• Number functions
• Record functions
• Replacer functions
• Splitter functions
• Table functions
• Text functions
• Time functions
• Type functions
• Uri functions
• Value functions