This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
      • SharePoint Server 2013 resources
      • SQL Server 2014 Express resources
      • Windows Server 2012 resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Servers and Enterprise Development Query and Data Modeling Languages Power Query (M) Formula Reference
Power Query (M) Formula Reference Power Query M function reference
Power Query M function reference
Power Query M function reference
Power Query M language specification
Power Query M type system
Power Query M function reference
Understanding Power Query M functions
Accessing data functions
Action functions
Binary functions
Combiner functions
Comparer functions
Date functions
DateTime functions
DateTimeZone functions
Duration functions
Error handling
Expression functions
Function values
Lines functions
List functions
Logical functions
Number functions
Record functions
Replacer functions
Splitter functions
Table functions
Text functions
Time functions
Type functions
Uri functions
Value functions
Quick tour
Expressions, values, and let expression
Comments
Evaluation model
Operators
Type conversion
Metadata
Errors
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.

Power Query M function reference

 

The Power Query M formula language includes the following function categories.

In this section

  • Accessing data functions
  • Action 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
Show:
Print Export (0)
Print Share
IN THIS ARTICLE
    Is this page helpful?
    Additional feedback?
    1500 characters remaining
    Thank you! We appreciate your feedback.

    Dev centers

    • Windows
    • Office
    • Visual Studio
    • Microsoft Azure
    • More...

    Learning resources

    • Microsoft Virtual Academy
    • Channel 9
    • MSDN Magazine

    Community

    • Forums
    • Blogs
    • Codeplex

    Support

    • Self support

    Programs

    • BizSpark (for startups)
    • Microsoft Imagine (for students)
    United States (English)
    • Newsletter
    • Privacy & cookies
    • Terms of use
    • Trademarks
    logo © 2017 Microsoft
    © 2017 Microsoft