Scribd
Upload
1K views15 pages

Power Query M Function Reference Guide

This document provides a reference to the functions available in Power Query M, a formula language used for data transformation. It lists over 200 functions organized into categories such as data accessing, binary, date, table, text and more. Each function is accompanied by a brief description.

Uploaded by

Pedro Ernesto Souza
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1K views15 pages

Power Query M Function Reference Guide

This document provides a reference to the functions available in Power Query M, a formula language used for data transformation. It lists over 200 functions organized into categories such as data accessing, binary, date, table, text and more. Each function is accompanied by a brief description.

Uploaded by

Pedro Ernesto Souza
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
  • Table of Contents
  • Function Categories

Power Query M function reference

In this section
• 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

Power Query M Reference


Power Query M language specification
Power Query M type system
Power Query M function reference
Understanding Power Query M functions
Accessing data functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Binary functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
BinaryEncoding.Base64
[Link]
BinaryFormat.7BitEncodedSignedInteger
BinaryFormat.7BitEncodedUnsignedInteger
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
BinaryFormat.SignedInteger16
BinaryFormat.SignedInteger32
BinaryFormat.SignedInteger64
[Link]
[Link]
[Link]
BinaryFormat.UnsignedInteger16
BinaryFormat.UnsignedInteger32
BinaryFormat.UnsignedInteger64
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#binary
Combiner functions
[Link]
[Link]
[Link]
[Link]
[Link]
Comparer functions
[Link]
[Link]
[Link]
[Link]
[Link]
Date functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#date
DateTime functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#datetime
DateTimeZone functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#datetimezone
Duration functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#duration
Error handling
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Expression functions
[Link]
[Link]
[Link]
Function values
[Link]
[Link]
[Link]
[Link]
Lines functions
[Link]
[Link]
[Link]
[Link]
List functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Logical functions
[Link]
[Link]
[Link]
Number functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Number.Atan2
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Number.E
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Number.Log10
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Record functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Replacer functions
[Link]
[Link]
Splitter functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Table functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#table
Text functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
TextEncoding.Utf8
TextEncoding.Utf16
[Link]
Time functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
#time
Type functions
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Uri functions
[Link]
[Link]
[Link]
[Link]
Value functions
Quick tour of the Power Query M formula language
Expressions, values, and let expression
Comments
Evaluation model
Operators
Type conversion
Metadata
Errors

Power Query M function reference In this section • Accessing data functions • Binary functions • Combiner functions •
AzureStorage.Tables Csv.Document (https://msdn.microsoft.com/pt-br/query-bi/m/azurestorage-tables) CsvStyle.QuoteAfterDelim
SapHanaRangeOperator.Equals SapHanaRangeOperator.Greater (https://msdn.microsoft.com/pt-br/query-bi/m/saphanarangeoperator-e
BinaryFormat.SignedInteger16 BinaryFormat.SignedInteger32 (https://msdn.microsoft.com/pt-br/query-bi/m/binaryformat-signedi
Date.IsInCurrentMonth Date.IsInCurrentQuarter (https://msdn.microsoft.com/pt-br/query-bi/m/date-isincurrentmonth) Date.IsIn
DateTime.FromFileTime DateTime.FromText (https://msdn.microsoft.com/pt-br/query-bi/m/datetime-fromfiletime) DateTime.IsInCu
#duration Error hand (https://msdn.microsoft.com/pt-br/query-bi/m/sharpduration)ling Diagnostics.ActivityId Diagnostics.Tr
List.LastN List.Match (https://msdn.microsoft.com/pt-br/query-bi/m/list-lastn)esAll List.MatchesAny List.Max (https://msd
Int32.From Int64.From (https://msdn.microsoft.com/pt-br/query-bi/m/int32-from) Number.Abs Number.Acos (https://msdn.micros
RoundingMode.Down RoundingMode.ToEven (https://msdn.microsoft.com/pt-br/query-bi/m/roundingmode-down) RoundingMode.TowardZe

You might also like