logo资料库

Power Query M 函数中文帮助手册20170804.pdf

发布时间：2022-06-16 发布人：admin 分类：说明书 资料大小：2.72M 资料格式：pdf 举报 版权申诉
第1页 / 共298页
第2页 / 共298页
第3页 / 共298页
第4页 / 共298页
第5页 / 共298页
第6页 / 共298页
第7页 / 共298页
第8页 / 共298页
资料共298页，剩余部分请下载后查看
    Power Query M 函数中文帮助手册
     Access.Database
     ActiveDirectory.Domains
     AdoDotNet.DataSource
     AdoDotNet.Query
     AmazonRedshift.Database
     AnalysisServices.Database
     AnalysisServices.Databases
     Any.Type
     ApacheSpark.Tables
     AzureEnterprise.Contents
     AzureEnterprise.Tables
     AzureSpark.Tables
     AzureStorage.Blobs
     AzureStorage.Tables
     Binary.Buffer
     Binary.Combine
     Binary.Compress
     Binary.Decompress
     Binary.From
     Binary.FromList
     Binary.FromText
     Binary.Length
     Binary.ToList
     Binary.ToText
     Binary.Type
     BinaryEncoding.Base64
     BinaryEncoding.Hex
     BinaryEncoding.Type
     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
     BinaryOccurrence.Type
     Byte.From
     Byte.Type
     ByteOrder.BigEndian
     ByteOrder.LittleEndian
     ByteOrder.Type
     Character.FromNumber
     Character.ToNumber
     Character.Type
     Combiner.CombineTextByDelimiter
     Combiner.CombineTextByEachDelimiter
     Combiner.CombineTextByLengths
     Combiner.CombineTextByPositions
     Combiner.CombineTextByRanges
     Comparer.Equals
     Comparer.FromCulture
     Comparer.Ordinal
     Comparer.OrdinalIgnoreCase
     Compression.Deflate
     Compression.GZip
     Compression.Type
     Csv.Document
     CsvStyle.QuoteAfterDelimiter
     CsvStyle.QuoteAlways
     CsvStyle.Type
     Cube.AddAndExpandDimensionColumn
     Cube.AddMeasureColumn
     Cube.ApplyParameter
     Cube.AttributeMemberId
     Cube.CollapseAndRemoveColumns
     Cube.Dimensions
     Cube.DisplayFolders
     Cube.Measures
     Cube.Parameters
     Cube.ReplaceDimensions
     Cube.Transform
     Culture.Current
     Currency.From
     Currency.Type
     CustomerInsights.Tables
     DB2.Database
     DataLake.Contents
     DataLake.Files
     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.Type
     Date.WeekOfMonth
     Date.WeekOfYear
     Date.Year
     DateTime.AddZone
     DateTime.Date
     DateTime.FixedLocalNow
     DateTime.From
     DateTime.FromFileTime
     DateTime.FromText
     DateTime.IsInCurrentHour
     DateTime.IsInCurrentMinute
     DateTime.IsInCurrentSecond
     DateTime.IsInNextHour
     DateTime.IsInNextMinute
     DateTime.IsInNextNHours
     DateTime.IsInNextNMinutes
     DateTime.IsInNextNSeconds
     DateTime.IsInNextSecond
     DateTime.IsInPreviousHour
     DateTime.IsInPreviousMinute
     DateTime.IsInPreviousNHours
     DateTime.IsInPreviousNMinutes
     DateTime.IsInPreviousNSeconds
     DateTime.IsInPreviousSecond
     DateTime.LocalNow
     DateTime.Time
     DateTime.ToRecord
     DateTime.ToText
     DateTime.Type
     DateTimeZone.FixedLocalNow
     DateTimeZone.FixedUtcNow
     DateTimeZone.From
     DateTimeZone.FromFileTime
     DateTimeZone.FromText
     DateTimeZone.LocalNow
     DateTimeZone.RemoveZone
     DateTimeZone.SwitchZone
     DateTimeZone.ToLocal
     DateTimeZone.ToRecord
     DateTimeZone.ToText
     DateTimeZone.ToUtc
     DateTimeZone.Type
     DateTimeZone.UtcNow
     DateTimeZone.ZoneHours
     DateTimeZone.ZoneMinutes
     Day.Friday
     Day.Monday
     Day.Saturday
     Day.Sunday
     Day.Thursday
     Day.Tuesday
     Day.Type
     Day.Wednesday
     Decimal.From
     Decimal.Type
     Diagnostics.ActivityId
     Diagnostics.Trace
     DirectQueryCapabilities.From
     DocumentDB.Contents
     Double.From
     Double.Type
     Duration.Days
     Duration.From
     Duration.FromText
     Duration.Hours
     Duration.Minutes
     Duration.Seconds
     Duration.ToRecord
     Duration.ToText
     Duration.TotalDays
     Duration.TotalHours
     Duration.TotalMinutes
     Duration.TotalSeconds
     Duration.Type
     DynamicsFinancials.Contents
     DynamicsFinancials.Feed
     Embedded.Value
     Error.Record
     Excel.CurrentWorkbook
     Excel.Workbook
     Exchange.Contents
     Expression.Constant
     Expression.Evaluate
     Expression.Identifier
     ExtraValues.Error
     ExtraValues.Ignore
     ExtraValues.List
     ExtraValues.Type
     Facebook.Graph
     File.Contents
     Folder.Contents
     Folder.Files
     Function.Invoke
     Function.InvokeAfter
     Function.IsDataSource
     Function.Type
     Github.Contents
     Github.PagedTable
     Github.Tables
     GoogleAnalytics.Accounts
     GroupKind.Global
     GroupKind.Local
     GroupKind.Type
     HdInsight.Containers
     HdInsight.Contents
     HdInsight.Files
     Hdfs.Contents
     Hdfs.Files
     Impala.Database
     Informix.Database
     Int16.From
     Int16.Type
     Int32.From
     Int32.Type
     Int64.From
     Int64.Type
     Int8.From
     Int8.Type
     JoinAlgorithm.Dynamic
     JoinAlgorithm.LeftHash
     JoinAlgorithm.LeftIndex
     JoinAlgorithm.PairwiseHash
     JoinAlgorithm.RightHash
     JoinAlgorithm.RightIndex
     JoinAlgorithm.SortMerge
     JoinAlgorithm.Type
     JoinKind.FullOuter
     JoinKind.Inner
     JoinKind.LeftAnti
     JoinKind.LeftOuter
     JoinKind.RightAnti
     JoinKind.RightOuter
     JoinKind.Type
     Json.Document
     Json.FromValue
     Lines.FromBinary
     Lines.FromText
     Lines.ToBinary
     Lines.ToText
     List.Accumulate
     List.AllTrue
     List.Alternate
     List.AnyTrue
     List.Average
     List.Buffer
     List.Combine
     List.Contains
     List.ContainsAll
     List.ContainsAny
     List.Count
     List.Covariance
     List.DateTimeZones
     List.DateTimes
     List.Dates
     List.Difference
     List.Distinct
     List.Durations
     List.FindText
     List.First
     List.FirstN
     List.Generate
     List.InsertRange
     List.Intersect
     List.IsDistinct
     List.IsEmpty
     List.Last
     List.LastN
     List.MatchesAll
     List.MatchesAny
     List.Max
     List.MaxN
     List.Median
     List.Min
     List.MinN
     List.Mode
     List.Modes
     List.NonNullCount
     List.Numbers
     List.PositionOf
     List.PositionOfAny
     List.Positions
     List.Product
     List.Random
     List.Range
     List.RemoveFirstN
     List.RemoveItems
     List.RemoveLastN
     List.RemoveMatchingItems
     List.RemoveNulls
     List.RemoveRange
     List.Repeat
     List.ReplaceMatchingItems
     List.ReplaceRange
     List.ReplaceValue
     List.Reverse
     List.Select
     List.Single
     List.SingleOrDefault
     List.Skip
     List.Sort
     List.StandardDeviation
     List.Sum
     List.Times
     List.Transform
     List.TransformMany
     List.Type
     List.Union
     List.Zip
     Logical.From
     Logical.FromText
     Logical.ToText
     Logical.Type
     MailChimp.Collection
     MailChimp.Instance
     MailChimp.Tables
     MailChimp.TablesV2
     Marketo.Activities
     Marketo.Leads
     Marketo.Tables
     Marketplace.Subscriptions
     MissingField.Error
     MissingField.Ignore
     MissingField.Type
     MissingField.UseNull
     Mixpanel.Contents
     Mixpanel.Export
     Mixpanel.FunnelById
     Mixpanel.FunnelByName
     Mixpanel.Funnels
     Mixpanel.Segmentation
     Mixpanel.Tables
     MySQL.Database
     Netezza.Database
     None.Type
     Null.Type
     Number.Abs
     Number.Acos
     Number.Asin
     Number.Atan
     Number.Atan2
     Number.BitwiseAnd
     Number.BitwiseNot
     Number.BitwiseOr
     Number.BitwiseShiftLeft
     Number.BitwiseShiftRight
     Number.BitwiseXor
     Number.Combinations
     Number.Cos
     Number.Cosh
     Number.E
     Number.Epsilon
     Number.Exp
     Number.Factorial
     Number.From
     Number.FromText
     Number.IntegerDivide
     Number.IsEven
     Number.IsNaN
     Number.IsOdd
     Number.Ln
     Number.Log
     Number.Log10
     Number.Mod
     Number.NaN
     Number.NegativeInfinity
     Number.PI
     Number.Permutations
     Number.PositiveInfinity
     Number.Power
     Number.Random
     Number.RandomBetween
     Number.Round
     Number.RoundAwayFromZero
     Number.RoundDown
     Number.RoundTowardZero
     Number.RoundUp
     Number.Sign
     Number.Sin
     Number.Sinh
     Number.Sqrt
     Number.Tan
     Number.Tanh
     Number.ToText
     Number.Type
     OData.Feed
     Occurrence.All
     Occurrence.First
     Occurrence.Last
     Occurrence.Optional
     Occurrence.Repeating
     Occurrence.Required
     Occurrence.Type
     Odbc.DataSource
     Odbc.Query
     OleDb.DataSource
     OleDb.Query
     Oracle.Database
     Order.Ascending
     Order.Descending
     Order.Type
     Percentage.From
     Percentage.Type
     PlanviewEnterprise.CallQueryService
     PlanviewEnterprise.Feed
     PostgreSQL.Database
     Precision.Decimal
     Precision.Double
     Precision.Type
     Projectplace.Feed
     QuickBooks.Query
     QuickBooks.Report
     QuickBooks.Tables
     QuoteStyle.Csv
     QuoteStyle.None
     QuoteStyle.Type
     R.Execute
     RData.FromBinary
     Record.AddField
     Record.Combine
     Record.Field
     Record.FieldCount
     Record.FieldNames
     Record.FieldOrDefault
     Record.FieldValues
     Record.FromList
     Record.FromTable
     Record.HasFields
     Record.RemoveFields
     Record.RenameFields
     Record.ReorderFields
     Record.SelectFields
     Record.ToList
     Record.ToTable
     Record.TransformFields
     Record.Type
     RelativePosition.FromEnd
     RelativePosition.FromStart
     RelativePosition.Type
     Replacer.ReplaceText
     Replacer.ReplaceValue
     Resource.Access
     RoundingMode.AwayFromZero
     RoundingMode.Down
     RoundingMode.ToEven
     RoundingMode.TowardZero
     RoundingMode.Type
     RoundingMode.Up
     RowExpression.Column
     RowExpression.From
     RowExpression.Row
     SQLSentry.ODataFeed
     SQLSentry.Tables
     Salesforce.Data
     Salesforce.Reports
     SapBusinessWarehouse.Cubes
     SapHana.Database
     SapHanaDistribution.All
     SapHanaDistribution.Connection
     SapHanaDistribution.Off
     SapHanaDistribution.Statement
     SapHanaDistribution.Type
     SapHanaRangeOperator.Equals
     SapHanaRangeOperator.GreaterThan
     SapHanaRangeOperator.GreaterThanOrEquals
     SapHanaRangeOperator.LessThan
     SapHanaRangeOperator.LessThanOrEquals
     SapHanaRangeOperator.NotEquals
     SapHanaRangeOperator.Type
     SharePoint.Contents
     SharePoint.Files
     SharePoint.Tables
     Single.From
     Single.Type
     Smartsheet.Content
     Smartsheet.Query
     Smartsheet.Tables
     Snowflake.Databases
     Soda.Feed
     Spark.Tables
     SparkPost.GetContents
     SparkPost.GetMetrics
     SparkPost.Metrics
     SparkPost.NavTable
     SparkProtocol.Azure
     SparkProtocol.HTTP
     SparkProtocol.Standard
     SparkProtocol.Type
     Splitter.SplitByNothing
     Splitter.SplitTextByAnyDelimiter
     Splitter.SplitTextByDelimiter
     Splitter.SplitTextByEachDelimiter
     Splitter.SplitTextByLengths
     Splitter.SplitTextByPositions
     Splitter.SplitTextByRanges
     Splitter.SplitTextByRepeatedLengths
     Splitter.SplitTextByWhitespace
     Sql.Database
     Sql.Databases
     SqlExpression.SchemaFrom
     SqlExpression.ToExpression
     Stripe.Contents
     Stripe.Method
     Stripe.Tables
     SweetIQ.Contents
     SweetIQ.Tables
     Sybase.Database
     Table.AddColumn
     Table.AddIndexColumn
     Table.AddJoinColumn
     Table.AddKey
     Table.AggregateTableColumn
     Table.AlternateRows
     Table.Buffer
     Table.Column
     Table.ColumnCount
     Table.ColumnNames
     Table.ColumnsOfType
     Table.Combine
     Table.CombineColumns
     Table.Contains
     Table.ContainsAll
     Table.ContainsAny
     Table.DemoteHeaders
     Table.Distinct
     Table.DuplicateColumn
     Table.ExpandListColumn
     Table.ExpandRecordColumn
     Table.ExpandTableColumn
     Table.FillDown
     Table.FillUp
     Table.FilterWithDataTable
     Table.FindText
     Table.First
     Table.FirstN
     Table.FirstValue
     Table.FromColumns
     Table.FromList
     Table.FromPartitions
     Table.FromRecords
     Table.FromRows
     Table.FromValue
     Table.Group
     Table.HasColumns
     Table.InsertRows
     Table.IsDistinct
     Table.IsEmpty
     Table.Join
     Table.Keys
     Table.Last
     Table.LastN
     Table.MatchesAllRows
     Table.MatchesAnyRows
     Table.Max
     Table.MaxN
     Table.Min
     Table.MinN
     Table.NestedJoin
     Table.Partition
     Table.PartitionValues
     Table.Pivot
     Table.PositionOf
     Table.PositionOfAny
     Table.PrefixColumns
     Table.Profile
     Table.PromoteHeaders
     Table.Range
     Table.RemoveColumns
     Table.RemoveFirstN
     Table.RemoveLastN
     Table.RemoveMatchingRows
     Table.RemoveRows
     Table.RemoveRowsWithErrors
     Table.RenameColumns
     Table.ReorderColumns
     Table.Repeat
     Table.ReplaceErrorValues
     Table.ReplaceKeys
     Table.ReplaceMatchingRows
     Table.ReplaceRelationshipIdentity
     Table.ReplaceRows
     Table.ReplaceValue
     Table.ReverseRows
     Table.RowCount
     Table.Schema
     Table.SelectColumns
     Table.SelectRows
     Table.SelectRowsWithErrors
     Table.SingleRow
     Table.Skip
     Table.Sort
     Table.SplitColumn
     Table.ToColumns
     Table.ToList
     Table.ToRecords
     Table.ToRows
     Table.TransformColumnNames
     Table.TransformColumnTypes
     Table.TransformColumns
     Table.TransformRows
     Table.Transpose
     Table.Type
     Table.Unpivot
     Table.UnpivotOtherColumns
     Table.View
     Tables.GetRelationships
     Teradata.Database
     Text.AfterDelimiter
     Text.At
     Text.BeforeDelimiter
     Text.BetweenDelimiters
     Text.Clean
     Text.Combine
     Text.Contains
     Text.End
     Text.EndsWith
     Text.Format
     Text.From
     Text.FromBinary
     Text.Insert
     Text.Length
     Text.Lower
     Text.Middle
     Text.NewGuid
     Text.PadEnd
     Text.PadStart
     Text.PositionOf
     Text.PositionOfAny
     Text.Proper
     Text.Range
     Text.Remove
     Text.RemoveRange
     Text.Repeat
     Text.Replace
     Text.ReplaceRange
     Text.Split
     Text.SplitAny
     Text.Start
     Text.StartsWith
     Text.ToBinary
     Text.ToList
     Text.Trim
     Text.TrimEnd
     Text.TrimStart
     Text.Type
     Text.Upper
     TextEncoding.Ascii
     TextEncoding.BigEndianUnicode
     TextEncoding.Type
     TextEncoding.Unicode
     TextEncoding.Utf16
     TextEncoding.Utf8
     TextEncoding.Windows
     Time.EndOfHour
     Time.From
     Time.FromText
     Time.Hour
     Time.Minute
     Time.Second
     Time.StartOfHour
     Time.ToRecord
     Time.ToText
     Time.Type
     TraceLevel.Critical
     TraceLevel.Error
     TraceLevel.Information
     TraceLevel.Type
     TraceLevel.Verbose
     TraceLevel.Warning
     Troux.CustomFeed
     Troux.Feed
     Troux.TestConnection
     Twilio.Contents
     Twilio.Tables
     Twilio.URL
     Type.AddTableKey
     Type.ClosedRecord
     Type.Facets
     Type.ForFunction
     Type.ForRecord
     Type.FunctionParameters
     Type.FunctionRequiredParameters
     Type.FunctionReturn
     Type.Is
     Type.IsNullable
     Type.IsOpenRecord
     Type.ListItem
     Type.NonNullable
     Type.OpenRecord
     Type.RecordFields
     Type.ReplaceFacets
     Type.ReplaceTableKeys
     Type.TableColumn
     Type.TableKeys
     Type.TableRow
     Type.TableSchema
     Type.Type
     Type.Union
     Uri.BuildQueryString
     Uri.Combine
     Uri.EscapeDataString
     Uri.Parts
     VSTS.Contents
     VSTS.Feed
     VSTS.Views
     Value.Add
     Value.As
     Value.Compare
     Value.Divide
     Value.Equals
     Value.Firewall
     Value.FromText
     Value.Is
     Value.Metadata
     Value.Multiply
     Value.NativeQuery
     Value.NullableEquals
     Value.RemoveMetadata
     Value.ReplaceMetadata
     Value.ReplaceType
     Value.ResourceExpression
     Value.Subtract
     Value.Type
     Variable.Value
     Web.Contents
     Web.Page
     WebMethod.Delete
     WebMethod.Get
     WebMethod.Head
     WebMethod.Patch
     WebMethod.Post
     WebMethod.Put
     WebMethod.Type
     Webtrends.KeyMetrics
     Webtrends.Profile
     Webtrends.ReportContents
     Webtrends.Tables
     Xml.Document
     Xml.Tables
     Zendesk.Collection
     Zendesk.Tables
     appFigures.Content
     appFigures.Tables
     comScore.GetReport
     comScore.NavTable
     comScore.ReportItems
     tyGraph.Feed
     tyGraph.NavTable
    Power Query M 函数中文帮助手册 （2017 年 8 月 4 日） Power BI 之家 www.pbihome.net QQ 群 微信公众号 Microsoft Power Query For Excel & Power Bi Desktop Power Query M Formula Library Specification
     Access.Database ........................................................................................................................................................................................ 20  ActiveDirectory.Domains ....................................................................................................................................................................... 20  AdoDotNet.DataSource........................................................................................................................................................................... 20  AdoDotNet.Query .................................................................................................................................................................................... 21  AmazonRedshift.Database ..................................................................................................................................................................... 21  AnalysisServices.Database ..................................................................................................................................................................... 21  AnalysisServices.Databases ................................................................................................................................................................... 22  Any.Type .................................................................................................................................................................................................... 23  ApacheSpark.Tables ................................................................................................................................................................................ 23  AzureEnterprise.Contents ....................................................................................................................................................................... 23  AzureEnterprise.Tables ........................................................................................................................................................................... 24  AzureSpark.Tables ................................................................................................................................................................................... 24  AzureStorage.Blobs ................................................................................................................................................................................. 24  AzureStorage.Tables ................................................................................................................................................................................ 24  Binary.Buffer ............................................................................................................................................................................................. 25  Binary.Combine ........................................................................................................................................................................................ 25  Binary.Compress....................................................................................................................................................................................... 25  Binary.Decompress .................................................................................................................................................................................. 26  Binary.From ............................................................................................................................................................................................... 26  Binary.FromList ........................................................................................................................................................................................ 26  Binary.FromText....................................................................................................................................................................................... 27  Binary.Length ............................................................................................................................................................................................ 27  Binary.ToList ............................................................................................................................................................................................. 27  Binary.ToText ........................................................................................................................................................................................... 28  Binary.Type ............................................................................................................................................................................................... 28  BinaryEncoding.Base64 .......................................................................................................................................................................... 28  BinaryEncoding.Hex ................................................................................................................................................................................ 28  BinaryEncoding.Type .............................................................................................................................................................................. 28  BinaryFormat.7BitEncodedSignedInteger .......................................................................................................................................... 29  BinaryFormat.7BitEncodedUnsignedInteger ..................................................................................................................................... 29  BinaryFormat.Binary ............................................................................................................................................................................... 29  BinaryFormat.Byte ................................................................................................................................................................................... 29  BinaryFormat.ByteOrder ........................................................................................................................................................................ 29  BinaryFormat.Choice ............................................................................................................................................................................... 29  BinaryFormat.Decimal ............................................................................................................................................................................ 31  BinaryFormat.Double .............................................................................................................................................................................. 31  BinaryFormat.Group ................................................................................................................................................................................ 31  BinaryFormat.Length ............................................................................................................................................................................... 33  BinaryFormat.List .................................................................................................................................................................................... 34  BinaryFormat.Null ................................................................................................................................................................................... 35  BinaryFormat.Record .............................................................................................................................................................................. 35  BinaryFormat.SignedInteger16 ............................................................................................................................................................. 35  BinaryFormat.SignedInteger32 ............................................................................................................................................................. 36  BinaryFormat.SignedInteger64 ............................................................................................................................................................. 36  BinaryFormat.Single ................................................................................................................................................................................ 36  BinaryFormat.Text ................................................................................................................................................................................... 36
     BinaryFormat.Transform ........................................................................................................................................................................ 37  BinaryFormat.UnsignedInteger16 ........................................................................................................................................................ 37  BinaryFormat.UnsignedInteger32 ........................................................................................................................................................ 37  BinaryFormat.UnsignedInteger64 ........................................................................................................................................................ 37  BinaryOccurrence.Optional .................................................................................................................................................................... 38  BinaryOccurrence.Repeating ................................................................................................................................................................. 38  BinaryOccurrence.Required ................................................................................................................................................................... 38  BinaryOccurrence.Type .......................................................................................................................................................................... 38  Byte.From ................................................................................................................................................................................................... 38  Byte.Type ................................................................................................................................................................................................... 39  ByteOrder.BigEndian .............................................................................................................................................................................. 39  ByteOrder.LittleEndian ........................................................................................................................................................................... 39  ByteOrder.Type ......................................................................................................................................................................................... 40  Character.FromNumber........................................................................................................................................................................... 40  Character.ToNumber ............................................................................................................................................................................... 40  Character.Type .......................................................................................................................................................................................... 41  Combiner.CombineTextByDelimiter ................................................................................................................................................... 41  Combiner.CombineTextByEachDelimiter ......................................................................................................................................... 41  Combiner.CombineTextByLengths...................................................................................................................................................... 41  Combiner.CombineTextByPositions ................................................................................................................................................... 41  Combiner.CombineTextByRanges ....................................................................................................................................................... 41  Comparer.Equals....................................................................................................................................................................................... 42  Comparer.FromCulture ........................................................................................................................................................................... 42  Comparer.Ordinal ..................................................................................................................................................................................... 43  Comparer.OrdinalIgnoreCase ................................................................................................................................................................ 43  Compression.Deflate ................................................................................................................................................................................ 43  Compression.GZip ................................................................................................................................................................................... 43  Compression.Type .................................................................................................................................................................................... 44  Csv.Document ........................................................................................................................................................................................... 44  CsvStyle.QuoteAfterDelimiter .............................................................................................................................................................. 44  CsvStyle.QuoteAlways............................................................................................................................................................................ 45  CsvStyle.Type ........................................................................................................................................................................................... 45  Cube.AddAndExpandDimensionColumn ........................................................................................................................................... 45  Cube.AddMeasureColumn ..................................................................................................................................................................... 45  Cube.ApplyParameter .............................................................................................................................................................................. 46  Cube.AttributeMemberId ........................................................................................................................................................................ 46  Cube.CollapseAndRemoveColumns .................................................................................................................................................... 46  Cube.Dimensions ...................................................................................................................................................................................... 46  Cube.DisplayFolders ................................................................................................................................................................................ 47  Cube.Measures .......................................................................................................................................................................................... 47  Cube.Parameters ....................................................................................................................................................................................... 47  Cube.ReplaceDimensions ....................................................................................................................................................................... 47  Cube.Transform ........................................................................................................................................................................................ 47  Culture.Current .......................................................................................................................................................................................... 47  Currency.From .......................................................................................................................................................................................... 48  Currency.Type ........................................................................................................................................................................................... 48
     CustomerInsights.Tables ......................................................................................................................................................................... 48  DB2.Database ............................................................................................................................................................................................ 48  DataLake.Contents ................................................................................................................................................................................... 49  DataLake.Files ........................................................................................................................................................................................... 50  Date.AddDays ........................................................................................................................................................................................... 50  Date.AddMonths ....................................................................................................................................................................................... 50  Date.AddQuarters ..................................................................................................................................................................................... 51  Date.AddWeeks ........................................................................................................................................................................................ 51  Date.AddYears .......................................................................................................................................................................................... 52  Date.Day ..................................................................................................................................................................................................... 52  Date.DayOfWeek...................................................................................................................................................................................... 53  Date.DayOfWeekName........................................................................................................................................................................... 53  Date.DayOfYear ....................................................................................................................................................................................... 54  Date.DaysInMonth ................................................................................................................................................................................... 54  Date.EndOfDay ......................................................................................................................................................................................... 54  Date.EndOfMonth .................................................................................................................................................................................... 55  Date.EndOfQuarter .................................................................................................................................................................................. 55  Date.EndOfWeek ...................................................................................................................................................................................... 56  Date.EndOfYear ........................................................................................................................................................................................ 57  Date.From ................................................................................................................................................................................................... 57  Date.FromText .......................................................................................................................................................................................... 58  Date.IsInCurrentDay ................................................................................................................................................................................ 59  Date.IsInCurrentMonth ........................................................................................................................................................................... 59  Date.IsInCurrentQuarter ......................................................................................................................................................................... 59  Date.IsInCurrentWeek ............................................................................................................................................................................. 60  Date.IsInCurrentYear ............................................................................................................................................................................... 60  Date.IsInNextDay ..................................................................................................................................................................................... 60  Date.IsInNextMonth ................................................................................................................................................................................ 61  Date.IsInNextNDays ................................................................................................................................................................................ 61  Date.IsInNextNMonths ........................................................................................................................................................................... 61  Date.IsInNextNQuarters ......................................................................................................................................................................... 62  Date.IsInNextNWeeks ............................................................................................................................................................................. 62  Date.IsInNextNYears ............................................................................................................................................................................... 63  Date.IsInNextQuarter ............................................................................................................................................................................... 63  Date.IsInNextWeek .................................................................................................................................................................................. 63  Date.IsInNextYear .................................................................................................................................................................................... 64  Date.IsInPreviousDay .............................................................................................................................................................................. 64  Date.IsInPreviousMonth ......................................................................................................................................................................... 65  Date.IsInPreviousNDays ......................................................................................................................................................................... 65  Date.IsInPreviousNMonths .................................................................................................................................................................... 65  Date.IsInPreviousNQuarters .................................................................................................................................................................. 66  Date.IsInPreviousNWeeks ...................................................................................................................................................................... 66  Date.IsInPreviousNYears ....................................................................................................................................................................... 67  Date.IsInPreviousQuarter ....................................................................................................................................................................... 67  Date.IsInPreviousWeek ........................................................................................................................................................................... 67  Date.IsInPreviousYear ............................................................................................................................................................................. 68
     Date.IsInYearToDate ............................................................................................................................................................................... 68  Date.IsLeapYear ....................................................................................................................................................................................... 68  Date.Month................................................................................................................................................................................................. 69  Date.MonthName...................................................................................................................................................................................... 69  Date.QuarterOfYear ................................................................................................................................................................................. 69  Date.StartOfDay ........................................................................................................................................................................................ 70  Date.StartOfMonth ................................................................................................................................................................................... 70  Date.StartOfQuarter ................................................................................................................................................................................. 70  Date.StartOfWeek .................................................................................................................................................................................... 71  Date.StartOfYear ...................................................................................................................................................................................... 71  Date.ToRecord .......................................................................................................................................................................................... 71  Date.ToText ............................................................................................................................................................................................... 72  Date.Type ................................................................................................................................................................................................... 72  Date.WeekOfMonth ................................................................................................................................................................................. 72  Date.WeekOfYear .................................................................................................................................................................................... 73  Date.Year .................................................................................................................................................................................................... 73  DateTime.AddZone .................................................................................................................................................................................. 73  DateTime.Date .......................................................................................................................................................................................... 74  DateTime.FixedLocalNow ..................................................................................................................................................................... 74  DateTime.From ......................................................................................................................................................................................... 74  DateTime.FromFileTime ........................................................................................................................................................................ 75  DateTime.FromText ................................................................................................................................................................................. 75  DateTime.IsInCurrentHour .................................................................................................................................................................... 76  DateTime.IsInCurrentMinute................................................................................................................................................................. 77  DateTime.IsInCurrentSecond ................................................................................................................................................................ 77  DateTime.IsInNextHour ......................................................................................................................................................................... 77  DateTime.IsInNextMinute ...................................................................................................................................................................... 78  DateTime.IsInNextNHours .................................................................................................................................................................... 78  DateTime.IsInNextNMinutes................................................................................................................................................................. 79  DateTime.IsInNextNSeconds ................................................................................................................................................................ 79  DateTime.IsInNextSecond ..................................................................................................................................................................... 80  DateTime.IsInPreviousHour .................................................................................................................................................................. 80  DateTime.IsInPreviousMinute .............................................................................................................................................................. 80  DateTime.IsInPreviousNHours ............................................................................................................................................................. 81  DateTime.IsInPreviousNMinutes ......................................................................................................................................................... 81  DateTime.IsInPreviousNSeconds ......................................................................................................................................................... 81  DateTime.IsInPreviousSecond .............................................................................................................................................................. 82  DateTime.LocalNow ................................................................................................................................................................................ 82  DateTime.Time ......................................................................................................................................................................................... 82  DateTime.ToRecord ................................................................................................................................................................................. 83  DateTime.ToText...................................................................................................................................................................................... 83  DateTime.Type .......................................................................................................................................................................................... 84  DateTimeZone.FixedLocalNow ............................................................................................................................................................ 84  DateTimeZone.FixedUtcNow................................................................................................................................................................ 84  DateTimeZone.From ................................................................................................................................................................................ 84  DateTimeZone.FromFileTime ............................................................................................................................................................... 85
     DateTimeZone.FromText ....................................................................................................................................................................... 85  DateTimeZone.LocalNow ...................................................................................................................................................................... 86  DateTimeZone.RemoveZone ................................................................................................................................................................. 86  DateTimeZone.SwitchZone ................................................................................................................................................................... 87  DateTimeZone.ToLocal .......................................................................................................................................................................... 87  DateTimeZone.ToRecord ....................................................................................................................................................................... 88  DateTimeZone.ToText ............................................................................................................................................................................ 88  DateTimeZone.ToUtc .............................................................................................................................................................................. 89  DateTimeZone.Type ................................................................................................................................................................................ 89  DateTimeZone.UtcNow .......................................................................................................................................................................... 89  DateTimeZone.ZoneHours ..................................................................................................................................................................... 90  DateTimeZone.ZoneMinutes ................................................................................................................................................................. 90  Day.Friday .................................................................................................................................................................................................. 90  Day.Monday .............................................................................................................................................................................................. 90  Day.Saturday ............................................................................................................................................................................................. 90  Day.Sunday ................................................................................................................................................................................................ 90  Day.Thursday ............................................................................................................................................................................................ 91  Day.Tuesday .............................................................................................................................................................................................. 91  Day.Type .................................................................................................................................................................................................... 91  Day.Wednesday ........................................................................................................................................................................................ 91  Decimal.From ............................................................................................................................................................................................ 91  Decimal.Type ............................................................................................................................................................................................ 92  Diagnostics.ActivityId ............................................................................................................................................................................. 92  Diagnostics.Trace ..................................................................................................................................................................................... 92  DirectQueryCapabilities.From .............................................................................................................................................................. 93  DocumentDB.Contents............................................................................................................................................................................ 93  Double.From .............................................................................................................................................................................................. 93  Double.Type .............................................................................................................................................................................................. 93  Duration.Days ............................................................................................................................................................................................ 93  Duration.From ........................................................................................................................................................................................... 94  Duration.FromText ................................................................................................................................................................................... 94  Duration.Hours .......................................................................................................................................................................................... 95  Duration.Minutes ...................................................................................................................................................................................... 95  Duration.Seconds ...................................................................................................................................................................................... 95  Duration.ToRecord ................................................................................................................................................................................... 96  Duration.ToText........................................................................................................................................................................................ 96  Duration.TotalDays .................................................................................................................................................................................. 97  Duration.TotalHours ................................................................................................................................................................................ 97  Duration.TotalMinutes ............................................................................................................................................................................ 97  Duration.TotalSeconds ............................................................................................................................................................................ 97  Duration.Type ............................................................................................................................................................................................ 98  DynamicsFinancials.Contents................................................................................................................................................................ 98  DynamicsFinancials.Feed ....................................................................................................................................................................... 98  Embedded.Value ....................................................................................................................................................................................... 98  Error.Record .............................................................................................................................................................................................. 98  Excel.CurrentWorkbook ......................................................................................................................................................................... 98
     Excel.Workbook ....................................................................................................................................................................................... 99  Exchange.Contents ................................................................................................................................................................................... 99  Expression.Constant ................................................................................................................................................................................. 99  Expression.Evaluate ................................................................................................................................................................................. 99  Expression.Identifier ................................................................................................................................................................................ 99  ExtraValues.Error ..................................................................................................................................................................................... 99  ExtraValues.Ignore ................................................................................................................................................................................. 100  ExtraValues.List...................................................................................................................................................................................... 100  ExtraValues.Type ................................................................................................................................................................................... 100  Facebook.Graph ...................................................................................................................................................................................... 100  File.Contents ............................................................................................................................................................................................ 100  Folder.Contents ....................................................................................................................................................................................... 100  Folder.Files .............................................................................................................................................................................................. 101  Function.Invoke ...................................................................................................................................................................................... 101  Function.InvokeAfter ............................................................................................................................................................................. 101  Function.IsDataSource .......................................................................................................................................................................... 101  Function.Type .......................................................................................................................................................................................... 101  Github.Contents ...................................................................................................................................................................................... 102  Github.PagedTable ................................................................................................................................................................................. 102  Github.Tables .......................................................................................................................................................................................... 102  GoogleAnalytics.Accounts ................................................................................................................................................................... 102  GroupKind.Global .................................................................................................................................................................................. 102  GroupKind.Local .................................................................................................................................................................................... 102  GroupKind.Type ..................................................................................................................................................................................... 102  HdInsight.Containers ............................................................................................................................................................................. 103  HdInsight.Contents ................................................................................................................................................................................. 103  HdInsight.Files ........................................................................................................................................................................................ 103  Hdfs.Contents .......................................................................................................................................................................................... 103  Hdfs.Files .................................................................................................................................................................................................. 103 Impala.Database ...................................................................................................................................................................................... 104  Informix.Database .................................................................................................................................................................................. 104   Int16.From ................................................................................................................................................................................................ 105 Int16.Type ................................................................................................................................................................................................ 105  Int32.From ................................................................................................................................................................................................ 105   Int32.Type ................................................................................................................................................................................................ 106 Int64.From ................................................................................................................................................................................................ 106  Int64.Type ................................................................................................................................................................................................ 107   Int8.From .................................................................................................................................................................................................. 107 Int8.Type ................................................................................................................................................................................................... 108  JoinAlgorithm.Dynamic ........................................................................................................................................................................ 108   JoinAlgorithm.LeftHash ....................................................................................................................................................................... 108 JoinAlgorithm.LeftIndex ...................................................................................................................................................................... 108  JoinAlgorithm.PairwiseHash ............................................................................................................................................................... 108   JoinAlgorithm.RightHash ..................................................................................................................................................................... 109 JoinAlgorithm.RightIndex .................................................................................................................................................................... 109   JoinAlgorithm.SortMerge ..................................................................................................................................................................... 109
    JoinAlgorithm.Type ............................................................................................................................................................................... 109  JoinKind.FullOuter ................................................................................................................................................................................. 109  JoinKind.Inner ......................................................................................................................................................................................... 109  JoinKind.LeftAnti ................................................................................................................................................................................... 110  JoinKind.LeftOuter ................................................................................................................................................................................ 110  JoinKind.RightAnti ................................................................................................................................................................................ 110  JoinKind.RightOuter .............................................................................................................................................................................. 110  JoinKind.Type ......................................................................................................................................................................................... 111  Json.Document ........................................................................................................................................................................................ 111   Json.FromValue ...................................................................................................................................................................................... 111  Lines.FromBinary ................................................................................................................................................................................... 112  Lines.FromText ....................................................................................................................................................................................... 112  Lines.ToBinary ........................................................................................................................................................................................ 112  Lines.ToText ............................................................................................................................................................................................ 113  List.Accumulate ...................................................................................................................................................................................... 113  List.AllTrue .............................................................................................................................................................................................. 113  List.Alternate ........................................................................................................................................................................................... 114  List.AnyTrue ............................................................................................................................................................................................ 115  List.Average ............................................................................................................................................................................................. 115  List.Buffer ................................................................................................................................................................................................ 115  List.Combine ........................................................................................................................................................................................... 116  List.Contains ............................................................................................................................................................................................ 116  List.ContainsAll ...................................................................................................................................................................................... 117  List.ContainsAny .................................................................................................................................................................................... 117  List.Count ................................................................................................................................................................................................. 118  List.Covariance ....................................................................................................................................................................................... 118  List.DateTimeZones ............................................................................................................................................................................... 119  List.DateTimes ........................................................................................................................................................................................ 119  List.Dates .................................................................................................................................................................................................. 120  List.Difference ......................................................................................................................................................................................... 120  List.Distinct .............................................................................................................................................................................................. 121  List.Durations .......................................................................................................................................................................................... 121  List.FindText ........................................................................................................................................................................................... 121  List.First .................................................................................................................................................................................................... 121  List.FirstN................................................................................................................................................................................................. 122  List.Generate ............................................................................................................................................................................................ 122  List.InsertRange ...................................................................................................................................................................................... 123  List.Intersect ............................................................................................................................................................................................ 124  List.IsDistinct .......................................................................................................................................................................................... 124  List.IsEmpty ............................................................................................................................................................................................. 125  List.Last .................................................................................................................................................................................................... 125  List.LastN ................................................................................................................................................................................................. 126  List.MatchesAll ....................................................................................................................................................................................... 126  List.MatchesAny ..................................................................................................................................................................................... 127  List.Max .................................................................................................................................................................................................... 127  List.MaxN................................................................................................................................................................................................. 128
    分享到：
    赞 收藏

    相关推荐

    资料库

    行业

    共收录7266份资料，累计15个分类，关注成员有19位，主要包括：物流,旅游,餐饮零售,网络游戏,咨询,金融,电子政务,外包,教育,制造,医疗,嵌入式,互联网,交通,电信

    热门标签

    物流 旅游 餐饮零售 网络游戏 咨询 金融 电子政务 外包 教育 制造 医疗 嵌入式 互联网 交通 电信

    最新资料