Power Query M function reference | Microsoft Docs

[Pages:864]Contents

Power Query M formula language Power Query M functions Power Query M functions overview Understanding Power Query M functions Accessing data functions Accessing data functions overview AccessControlEntry.ConditionToIdentities AccessControlKind.Allow AccessControlKind.Deny Access.Database ActiveDirectory.Domains AdobeAnalytics.Cubes AdoDotNet.DataSource AdoDotNet.Query AnalysisServices.Database AnalysisServices.Databases AzureStorage.BlobContents AzureStorage.Blobs AzureStorage.DataLake AzureStorage.DataLakeContents AzureStorage.Tables Csv.Document CsvStyle.QuoteAfterDelimiter CsvStyle.QuoteAlways Cube.AddAndExpandDimensionColumn Cube.AddMeasureColumn Cube.ApplyParameter Cube.AttributeMemberId Cube.AttributeMemberProperty

Cube.CollapseAndRemoveColumns Cube.Dimensions Cube.DisplayFolders Cube.MeasureProperties Cube.MeasureProperty Cube.Measures Cube.Parameters Cube.Properties Cube.PropertyKey Cube.ReplaceDimensions Cube.Transform DB2.Database Essbase.Cubes Excel.CurrentWorkbook Excel.Workbook Exchange.Contents Facebook.Graph File.Contents Folder.Contents Folder.Files GoogleAnalytics.Accounts Hdfs.Contents Hdfs.Files HdInsight.Containers HdInsight.Contents HdInsight.Files Html.Table Identity.From Identity.IsMemberOf IdentityProvider.Default Informix.Database Json.Document

Json.FromValue MySQL.Database OData.Feed ODataOmitValues.Nulls Odbc.DataSource Odbc.InferOptions Odbc.Query OleDb.DataSource OleDb.Query Oracle.Database Pdf.Tables PostgreSQL.Database RData.FromBinary Salesforce.Data Salesforce.Reports SapBusinessWarehouse.Cubes SapBusinessWarehouseExecutionMode.DataStream SapBusinessWarehouseExecutionMode.BasXml SapBusinessWarehouseExecutionMode.BasXmlGzip SapHana.Database SapHanaDistribution.All SapHanaDistribution.Connection SapHanaDistribution.Off SapHanaDistribution.Statement SapHanaRangeOperator.Equals SapHanaRangeOperator.GreaterThan SapHanaRangeOperator.GreaterThanOrEquals SapHanaRangeOperator.LessThan SapHanaRangeOperator.LessThanOrEquals SapHanaRangeOperator.NotEquals SharePoint.Contents SharePoint.Files

SharePoint.Tables Soda.Feed Sql.Database Sql.Databases Sybase.Database Teradata.Database WebAction.Request Web.BrowserContents Web.Contents Web.Page WebMethod.Delete WebMethod.Get WebMethod.Head WebMethod.Patch WebMethod.Post WebMethod.Put Xml.Document Xml.Tables Binary functions Binary functions overview Binary.Buffer bine press Binary.Decompress Binary.From Binary.FromList Binary.FromText Binary.InferContentType Binary.Length Binary.ToList Binary.ToText BinaryEncoding.Base64

BinaryEncoding.Hex BinaryFormat.7BitEncodedSignedInteger BinaryFormat.7BitEncodedUnsignedInteger BinaryFormat.Binary BinaryFormat.Byte BinaryFormat.ByteOrder BinaryFormat.Choice BinaryFormat.Decimal BinaryFormat.Double BinaryFormat.Group BinaryFormat.Length BinaryFormat.List BinaryFormat.Null BinaryFormat.Record BinaryFormat.SignedInteger16 BinaryFormat.SignedInteger32 BinaryFormat.SignedInteger64 BinaryFormat.Single BinaryFormat.Text BinaryFormat.Transform BinaryFormat.UnsignedInteger16 BinaryFormat.UnsignedInteger32 BinaryFormat.UnsignedInteger64 BinaryOccurrence.Optional BinaryOccurrence.Repeating BinaryOccurrence.Required ByteOrder.BigEndian ByteOrder.LittleEndian Compression.Deflate Compression.GZip Occurrence.Optional Occurrence.Repeating

Occurrence.Required #binary Combiner functions Combiner functions overview bineTextByDelimiter bineTextByEachDelimiter bineTextByLengths bineTextByPositions bineTextByRanges Comparer functions Comparer functions overview Comparer.Equals Comparer.FromCulture Comparer.Ordinal Comparer.OrdinalIgnoreCase Culture.Current Date functions Date functions overview Date.AddDays Date.AddMonths Date.AddQuarters Date.AddWeeks Date.AddYears Date.Day Date.DayOfWeek Date.DayOfWeekName Date.DayOfYear Date.DaysInMonth Date.EndOfDay Date.EndOfMonth Date.EndOfQuarter Date.EndOfWeek

Date.EndOfYear Date.From Date.FromText Date.IsInCurrentDay Date.IsInCurrentMonth Date.IsInCurrentQuarter Date.IsInCurrentWeek Date.IsInCurrentYear Date.IsInNextDay Date.IsInNextMonth Date.IsInNextNDays Date.IsInNextNMonths Date.IsInNextNQuarters Date.IsInNextNWeeks Date.IsInNextNYears Date.IsInNextQuarter Date.IsInNextWeek Date.IsInNextYear Date.IsInPreviousDay Date.IsInPreviousMonth Date.IsInPreviousNDays Date.IsInPreviousNMonths Date.IsInPreviousNQuarters Date.IsInPreviousNWeeks Date.IsInPreviousNYears Date.IsInPreviousQuarter Date.IsInPreviousWeek Date.IsInPreviousYear Date.IsInYearToDate Date.IsLeapYear Date.Month Date.MonthName

Date.QuarterOfYear Date.StartOfDay Date.StartOfMonth Date.StartOfQuarter Date.StartOfWeek Date.StartOfYear Date.ToRecord Date.ToText Date.WeekOfMonth Date.WeekOfYear Date.Year Day.Friday Day.Monday Day.Saturday Day.Sunday Day.Thursday Day.Tuesday Day.Wednesday #date DateTime functions DateTime functions overview DateTime.AddZone DateTime.Date DateTime.FixedLocalNow DateTime.From DateTime.FromFileTime DateTime.FromText DateTime.IsInCurrentHour DateTime.IsInCurrentMinute DateTime.IsInCurrentSecond DateTime.IsInNextHour DateTime.IsInNextMinute

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download