返回主页
说明
数据访问函数
访问数据函数概述
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
BufferMode.Delayed
BufferMode.Eager
Cdm.Contents
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
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
LimitClauseKind.AnsiSql2008
LimitClauseKind.Limit
LimitClauseKind.LimitOffset
LimitClauseKind.None
LimitClauseKind.Top
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.Headers
Web.Page
WebMethod.Delete
WebMethod.Get
WebMethod.Head
WebMethod.Patch
WebMethod.Post
WebMethod.Put
Xml.Document
Xml.Tables
二进制函数
Binary 函数概述
Binary.Buffer
Binary.Combine
Binary.Compress
Binary.Decompress
Binary.From
Binary.FromList
Binary.FromText
Binary.InferContentType
Binary.Length
Binary.Range
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.Brotli
Compression.Deflate
Compression.GZip
Compression.LZ4
Compression.None
Compression.Snappy
Compression.Zstandard
Occurrence.Optional
Occurrence.Repeating
Occurrence.Required
#binary
合并器函数
合并器函数概述
Combiner.CombineTextByDelimiter
Combiner.CombineTextByEachDelimiter
Combiner.CombineTextByLengths
Combiner.CombineTextByPositions
Combiner.CombineTextByRanges
比较器函数
比较器函数概述
Comparer.Equals
Comparer.FromCulture
Comparer.Ordinal
Comparer.OrdinalIgnoreCase
Culture.Current
日期函数
日期函数概述
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.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
日期/时间/时区函数
DateTimeZone 函数概述
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.UtcNow
DateTimeZone.ZoneHours
DateTimeZone.ZoneMinutes
TimeZone.Current
#datetimezone
持续时间函数
持续时间函数概述
Duration.Days
Duration.From
Duration.FromText
Duration.Hours
Duration.Minutes
Duration.Seconds
Duration.ToRecord
Duration.TotalDays
Duration.TotalHours
Duration.TotalMinutes
Duration.TotalSeconds
Duration.ToText
#duration
错误处理
错误处理概述
Diagnostics.ActivityId
Diagnostics.Trace
Error.Record
TraceLevel.Critical
TraceLevel.Error
TraceLevel.Information
TraceLevel.Verbose
TraceLevel.Warning
表达式函数
表达式函数概述
Expression.Constant
Expression.Evaluate
Expression.Identifier
函数值
函数值概述
Function.From
Function.Invoke
Function.InvokeAfter
Function.IsDataSource
Function.ScalarVector
行函数
行函数概述
Lines.FromBinary
Lines.FromText
Lines.ToBinary
Lines.ToText
列表函数
列表函数概述
List.Accumulate
List.AllTrue
List.Alternate
List.AnyTrue
List.Average
List.Buffer
List.Combine
List.ConformToPageReader
List.Contains
List.ContainsAll
List.ContainsAny
List.Count
List.Covariance
List.Dates
List.DateTimes
List.DateTimeZones
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.Percentile
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.Split
List.StandardDeviation
List.Sum
List.Times
List.Transform
List.TransformMany
List.Union
List.Zip
PercentileMode.ExcelExc
PercentileMode.ExcelInc
PercentileMode.SqlCont
PercentileMode.SqlDisc
逻辑函数
逻辑函数概述
Logical.From
Logical.FromText
Logical.ToText
数字函数
数字函数概述
Byte.From
Currency.From
Decimal.From
Double.From
Int8.From
Int16.From
Int32.From
Int64.From
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.Permutations
Number.PI
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
Percentage.From
RoundingMode.AwayFromZero
RoundingMode.Down
RoundingMode.ToEven
RoundingMode.TowardZero
RoundingMode.Up
Single.From
记录函数
记录函数概述
Geography.FromWellKnownText
Geography.ToWellKnownText
GeographyPoint.From
Geometry.FromWellKnownText
Geometry.ToWellKnownText
GeometryPoint.From
MissingField.Error
MissingField.Ignore
MissingField.UseNull
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
替换器函数
替换器函数概览
Replacer.ReplaceText
Replacer.ReplaceValue
拆分器函数
拆分器函数概述
QuoteStyle.Csv
QuoteStyle.None
Splitter.SplitByNothing
Splitter.SplitTextByAnyDelimiter
Splitter.SplitTextByCharacterTransition
Splitter.SplitTextByDelimiter
Splitter.SplitTextByEachDelimiter
Splitter.SplitTextByLengths
Splitter.SplitTextByPositions
Splitter.SplitTextByRanges
Splitter.SplitTextByRepeatedLengths
Splitter.SplitTextByWhitespace
表函数
表函数概述
ExtraValues.Error
ExtraValues.Ignore
ExtraValues.List
GroupKind.Global
GroupKind.Local
ItemExpression.From
ItemExpression.Item
JoinAlgorithm.Dynamic
JoinAlgorithm.LeftHash
JoinAlgorithm.LeftIndex
JoinAlgorithm.PairwiseHash
JoinAlgorithm.RightHash
JoinAlgorithm.RightIndex
JoinAlgorithm.SortMerge
JoinKind.FullOuter
JoinKind.Inner
JoinKind.LeftAnti
JoinKind.LeftOuter
JoinKind.RightAnti
JoinKind.RightOuter
JoinSide.Left
JoinSide.Right
Occurrence.All
Occurrence.First
Occurrence.Last
Order.Ascending
Order.Descending
RowExpression.Column
RowExpression.From
RowExpression.Row
Table.AddColumn
Table.AddFuzzyClusterColumn
Table.AddIndexColumn
Table.AddJoinColumn
Table.AddKey
Table.AggregateTableColumn
Table.AlternateRows
Table.ApproximateRowCount
Table.Buffer
Table.Column
Table.ColumnCount
Table.ColumnNames
Table.ColumnsOfType
Table.Combine
Table.CombineColumns
Table.CombineColumnsToRecord
Table.ConformToPageReader
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.FuzzyGroup
Table.FuzzyJoin
Table.FuzzyNestedJoin
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.Split
Table.SplitAt
Table.SplitColumn
Table.ToColumns
Table.ToList
Table.ToRecords
Table.ToRows
Table.TransformColumnNames
Table.TransformColumns
Table.TransformColumnTypes
Table.TransformRows
Table.Transpose
Table.Unpivot
Table.UnpivotOtherColumns
Table.View
Table.ViewFunction
Tables.GetRelationships
#table
文本函数
文本函数概述
Character.FromNumber
Character.ToNumber
Guid.From
Json.FromValue
RelativePosition.FromEnd
RelativePosition.FromStart
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.InferNumberType
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.Reverse
Text.Select
Text.Split
Text.SplitAny
Text.Start
Text.StartsWith
Text.ToBinary
Text.ToList
Text.Trim
Text.TrimEnd
Text.TrimStart
Text.Upper
TextEncoding.Ascii
TextEncoding.BigEndianUnicode
TextEncoding.Unicode
TextEncoding.Utf8
TextEncoding.Utf16
TextEncoding.Windows
时间函数
时间函数概述
Time.EndOfHour
Time.From
Time.FromText
Time.Hour
Time.Minute
Time.Second
Time.StartOfHour
Time.ToRecord
Time.ToText
#time
类型函数
类型函数概述
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.Union
Uri 函数
Uri 函数概述
Uri.BuildQueryString
Uri.Combine
Uri.EscapeDataString
Uri.Parts
值函数
值函数概述
DirectQueryCapabilities.From
Embedded.Value
Excel.ShapeTable
Graph.Nodes
Precision.Decimal
Precision.Double
SqlExpression.SchemaFrom
SqlExpression.ToExpression
Value.Add
Value.Alternate
Value.As
Value.Compare
Value.Divide
Value.Equals
Value.Expression
Value.Firewall
Value.FromText
Value.Is
Value.Lineage
Value.Metadata
Value.Multiply
Value.NativeQuery
Value.NullableEquals
Value.Optimize
Value.RemoveMetadata
Value.ReplaceMetadata
Value.ReplaceType
Value.Subtract
Value.Traits
Value.Type
Variable.Value
Published By Xifeng
说明
PowerQuery M函数手册
更新日期：2022/04/21
数据来源：
PowerQuery官方文档
Published By
Xifeng
results matching "
"
No results matching "
"
