Skip to content

Instantly share code, notes, and snippets.

@migueesc123
Created July 13, 2019 02:38
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save migueesc123/e859a602625fe9c91f867d2cc73eeda6 to your computer and use it in GitHub Desktop.
Save migueesc123/e859a602625fe9c91f867d2cc73eeda6 to your computer and use it in GitHub Desktop.
Value.ResourceExpression
Resource.Access
List.NonNullCount
List.MatchesAll
List.MatchesAny
List.Range
List.RemoveItems
List.ReplaceValue
List.FindText
List.RemoveLastN
List.RemoveFirstN
Table.ColumnCount
Table.AlternateRows
Table.InsertRows
Table.LastN
Table.Last
Table.MatchesAllRows
Table.MatchesAnyRows
Table.Partition
Table.Range
Table.RemoveRows
Table.Repeat
Table.ReplaceRows
Table.ReverseRows
Table.HasColumns
Table.PrefixColumns
Table.ColumnsOfType
Table.AddColumn
Table.DuplicateColumn
Table.FillUp
Table.RemoveLastN
Table.RemoveFirstN
Table.ExpandListColumn
Table.ExpandTableColumn
Table.TransformRows
Table.Transpose
Table.DemoteHeaders
Table.ToRows
Table.ToColumns
Table.Contains
Table.ContainsAll
Table.ContainsAny
Table.IsDistinct
Table.PositionOf
Table.PositionOfAny
Table.RemoveMatchingRows
Table.ReplaceMatchingRows
Table.Max
Table.MaxN
Table.Min
Table.MinN
Table.FindText
Replacer.ReplaceValue
Replacer.ReplaceText
Table.ReplaceValue
Table.IsEmpty
Table.SplitColumn
Table.CombineColumns
Table.FirstValue
Table.View
Table.Schema
Type.TableSchema
Table.Profile
Text.Format
RelativePosition.Type
RelativePosition.FromStart
RelativePosition.FromEnd
Text.AfterDelimiter
Text.BeforeDelimiter
Text.BetweenDelimiters
Date.IsInPreviousDay
Date.IsInPreviousNDays
Date.IsInCurrentDay
Date.IsInNextDay
Date.IsInNextNDays
Date.IsInPreviousWeek
Date.IsInPreviousNWeeks
Date.IsInCurrentWeek
Date.IsInNextWeek
Date.IsInNextNWeeks
Date.IsInPreviousMonth
Date.IsInPreviousNMonths
Date.IsInCurrentMonth
Date.IsInNextMonth
Date.IsInNextNMonths
Date.IsInPreviousQuarter
Date.IsInPreviousNQuarters
Date.IsInCurrentQuarter
Date.IsInNextQuarter
Date.IsInNextNQuarters
Date.IsInPreviousYear
Date.IsInPreviousNYears
Date.IsInCurrentYear
Date.IsInNextYear
Date.IsInNextNYears
Date.IsInYearToDate
DateTime.IsInPreviousSecond
DateTime.IsInPreviousNSeconds
DateTime.IsInNextSecond
DateTime.IsInNextNSeconds
DateTime.IsInCurrentSecond
DateTime.IsInPreviousMinute
DateTime.IsInPreviousNMinutes
DateTime.IsInNextMinute
DateTime.IsInNextNMinutes
DateTime.IsInCurrentMinute
DateTime.IsInPreviousHour
DateTime.IsInPreviousNHours
DateTime.IsInNextHour
DateTime.IsInNextNHours
DateTime.IsInCurrentHour
Date.MonthName
Date.DayOfWeekName
SqlExpression.SchemaFrom
DirectQueryCapabilities.From
List.Count
List.Distinct
List.FirstN
List.IsEmpty
List.LastN
List.Select
List.Skip
List.Sort
List.Transform
List.TransformMany
Any.Type
None.Type
Expression.Constant
Expression.Evaluate
Expression.Identifier
TextEncoding.Type
TextEncoding.Utf8
TextEncoding.Utf16
TextEncoding.Ascii
TextEncoding.Unicode
TextEncoding.BigEndianUnicode
TextEncoding.Windows
Culture.Current
Day.Type
Day.Sunday
Day.Monday
Day.Tuesday
Day.Wednesday
Day.Thursday
Day.Friday
Day.Saturday
Duration.Type
Duration.FromText
Duration.From
Duration.ToText
Duration.ToRecord
Duration.Days
Duration.Hours
Duration.Minutes
Duration.Seconds
Duration.TotalDays
Duration.TotalHours
Duration.TotalMinutes
Duration.TotalSeconds
JoinKind.Type
JoinKind.Inner
JoinKind.LeftOuter
JoinKind.RightOuter
JoinKind.FullOuter
JoinKind.LeftAnti
JoinKind.RightAnti
MissingField.Type
MissingField.Error
MissingField.Ignore
MissingField.UseNull
GroupKind.Type
GroupKind.Global
GroupKind.Local
Number.E
Number.PI
RoundingMode.Type
RoundingMode.Up
RoundingMode.Down
RoundingMode.AwayFromZero
RoundingMode.TowardZero
RoundingMode.ToEven
Record.Type
Record.AddField
Record.Field
Record.FieldCount
Record.FieldNames
Record.FieldOrDefault
Record.FieldValues
Record.FromTable
Record.HasFields
Record.RemoveFields
Record.RenameFields
Record.ReorderFields
Record.SelectFields
Record.ToTable
Record.TransformFields
Record.Combine
Record.FromList
Record.ToList
Precision.Type
Precision.Double
Precision.Decimal
Number.Type
Number.From
Number.FromText
Number.ToText
Number.IsNaN
Number.NaN
Number.NegativeInfinity
Number.PositiveInfinity
Number.Epsilon
Number.BitwiseNot
Number.BitwiseOr
Number.BitwiseAnd
Number.BitwiseXor
Number.BitwiseShiftLeft
Number.BitwiseShiftRight
BinaryEncoding.Type
BinaryEncoding.Hex
BinaryEncoding.Base64
Binary.Type
Binary.ToText
Binary.From
Binary.FromText
Binary.ToList
Binary.FromList
Binary.Combine
Binary.Length
Binary.Buffer
Binary.Compress
Binary.Decompress
Binary.InferContentType
Compression.Type
Compression.GZip
Compression.Deflate
Byte.Type
Character.Type
Character.FromNumber
Character.ToNumber
Text.Type
Text.At
Text.From
Text.Length
Text.Range
Text.Middle
Text.Start
Text.End
Text.StartsWith
Text.EndsWith
Text.Contains
Text.Clean
Text.PositionOf
Text.PositionOfAny
Text.Lower
Text.Upper
Text.Proper
Text.Split
Text.SplitAny
Text.Combine
Text.Repeat
Text.Replace
Text.ReplaceRange
Text.Insert
Text.Remove
Text.RemoveRange
Text.Reverse
Text.Select
Text.Trim
Text.TrimStart
Text.TrimEnd
Text.PadStart
Text.PadEnd
Text.ToBinary
Text.ToList
Text.FromBinary
Text.NewGuid
Text.InferNumberType
Comparer.FromCulture
Comparer.Ordinal
Comparer.OrdinalIgnoreCase
Comparer.Equals
Date.FromText
Date.From
Date.ToText
Date.ToRecord
Date.Year
Date.Month
Date.Day
Date.AddDays
Date.AddWeeks
Date.AddMonths
Date.AddQuarters
Date.AddYears
Date.IsLeapYear
Date.StartOfYear
Date.StartOfQuarter
Date.StartOfMonth
Date.StartOfWeek
Date.StartOfDay
Date.EndOfYear
Date.EndOfQuarter
Date.EndOfMonth
Date.EndOfWeek
Date.EndOfDay
Date.DayOfWeek
Date.DayOfYear
Date.DaysInMonth
Date.QuarterOfYear
Date.WeekOfMonth
Date.WeekOfYear
DateTime.FromText
DateTime.From
DateTime.ToText
DateTime.ToRecord
DateTime.Date
DateTime.Time
DateTime.AddZone
DateTime.LocalNow
DateTime.FixedLocalNow
DateTime.FromFileTime
DateTimeZone.FromText
DateTimeZone.From
DateTimeZone.ToText
DateTimeZone.ToRecord
DateTimeZone.ZoneHours
DateTimeZone.ZoneMinutes
DateTimeZone.LocalNow
DateTimeZone.UtcNow
DateTimeZone.FixedLocalNow
DateTimeZone.FixedUtcNow
DateTimeZone.ToLocal
DateTimeZone.ToUtc
DateTimeZone.SwitchZone
DateTimeZone.RemoveZone
DateTimeZone.FromFileTime
Time.FromText
Time.From
Time.ToText
Time.ToRecord
Time.Hour
Time.Minute
Time.Second
Time.StartOfHour
Time.EndOfHour
Function.Type
Function.From
Function.Invoke
Function.InvokeAfter
Function.IsDataSource
Function.ScalarVector
Null.Type
Number.Abs
Number.Acos
Number.Asin
Number.Atan
Number.Atan2
Number.Combinations
Number.Cos
Number.Cosh
Number.Exp
Number.Factorial
Number.IntegerDivide
Number.Log
Number.Log10
Number.Ln
Number.Mod
Number.Permutations
Number.Power
Number.Random
Number.RandomBetween
Number.Round
Number.RoundDown
Number.RoundUp
Number.RoundTowardZero
Number.RoundAwayFromZero
Number.Sign
Number.Sin
Number.Sinh
Number.Sqrt
Number.Tan
Number.Tanh
Number.IsEven
Number.IsOdd
List.Type
List.Contains
List.Difference
List.First
List.Generate
List.Intersect
List.IsDistinct
List.Last
List.RemoveMatchingItems
List.RemoveNulls
List.Repeat
List.ReplaceMatchingItems
List.Reverse
List.Single
List.SingleOrDefault
List.Union
List.Accumulate
List.Buffer
List.Combine
List.ContainsAll
List.ContainsAny
List.InsertRange
List.Max
List.MaxN
List.Min
List.MinN
List.PositionOf
List.PositionOfAny
List.Positions
List.RemoveRange
List.ReplaceRange
List.Alternate
List.Zip
List.Split
List.Average
List.Covariance
List.Median
List.Mode
List.Modes
List.Product
List.Sum
List.StandardDeviation
List.Numbers
List.Times
List.Dates
List.DateTimes
List.DateTimeZones
List.Durations
List.Random
Error.Record
Value.Equals
Value.NullableEquals
Value.Compare
Value.Type
Value.ReplaceType
Value.RemoveMetadata
Value.ReplaceMetadata
Value.Metadata
Value.FromText
Value.Add
Value.Subtract
Value.Multiply
Value.Divide
Value.As
Value.Is
Value.NativeQuery
Type.Type
Type.ForRecord
Type.ForFunction
Type.NonNullable
Type.IsNullable
Type.ListItem
Type.OpenRecord
Type.ClosedRecord
Type.IsOpenRecord
Type.RecordFields
Type.FunctionParameters
Type.FunctionRequiredParameters
Type.FunctionReturn
Type.Is
Type.Union
Type.Facets
Type.ReplaceFacets
Logical.Type
Logical.FromText
Logical.From
Logical.ToText
List.AllTrue
List.AnyTrue
Order.Type
Order.Ascending
Order.Descending
Occurrence.Type
Occurrence.All
Occurrence.First
Occurrence.Last
Int8.Type
Int16.Type
Int32.Type
Int64.Type
Single.Type
Double.Type
Decimal.Type
Currency.Type
Percentage.Type
Guid.Type
Uri.Type
Password.Type
Byte.From
Int8.From
Int16.From
Int32.From
Int64.From
Single.From
Double.From
Decimal.From
Currency.From
Percentage.From
Guid.From
Date.Type
DateTime.Type
DateTimeZone.Type
Time.Type
Value.Firewall
ByteOrder.Type
ByteOrder.LittleEndian
ByteOrder.BigEndian
Occurrence.Optional
Occurrence.Required
Occurrence.Repeating
BinaryOccurrence.Type
BinaryOccurrence.Optional
BinaryOccurrence.Required
BinaryOccurrence.Repeating
BinaryFormat.SignedInteger16
BinaryFormat.SignedInteger32
BinaryFormat.SignedInteger64
BinaryFormat.UnsignedInteger16
BinaryFormat.UnsignedInteger32
BinaryFormat.UnsignedInteger64
BinaryFormat.Single
BinaryFormat.Double
BinaryFormat.Decimal
BinaryFormat.7BitEncodedUnsignedInteger
BinaryFormat.7BitEncodedSignedInteger
BinaryFormat.Byte
BinaryFormat.Binary
BinaryFormat.Record
BinaryFormat.List
BinaryFormat.Text
BinaryFormat.Transform
BinaryFormat.Length
BinaryFormat.Choice
BinaryFormat.ByteOrder
BinaryFormat.Group
BinaryFormat.Null
Diagnostics.Trace
Diagnostics.ActivityId
TraceLevel.Type
TraceLevel.Critical
TraceLevel.Error
TraceLevel.Warning
TraceLevel.Information
TraceLevel.Verbose
Excel.Workbook
Json.Document
Json.FromValue
Csv.Document
Lines.FromText
Lines.FromBinary
Lines.ToText
Lines.ToBinary
Table.FromList
Table.ToList
Splitter.SplitByNothing
Splitter.SplitTextByCharacterTransition
Splitter.SplitTextByDelimiter
Splitter.SplitTextByRanges
Splitter.SplitTextByWhitespace
Splitter.SplitTextByEachDelimiter
Splitter.SplitTextByAnyDelimiter
Splitter.SplitTextByPositions
Splitter.SplitTextByRepeatedLengths
Splitter.SplitTextByLengths
Combiner.CombineTextByDelimiter
Combiner.CombineTextByEachDelimiter
Combiner.CombineTextByRanges
Combiner.CombineTextByPositions
Combiner.CombineTextByLengths
ExtraValues.Type
ExtraValues.List
ExtraValues.Ignore
ExtraValues.Error
QuoteStyle.Type
QuoteStyle.None
QuoteStyle.Csv
CsvStyle.Type
CsvStyle.QuoteAlways
CsvStyle.QuoteAfterDelimiter
Table.FromValue
Embedded.Value
SqlExpression.ToExpression
Table.Type
Table.ColumnNames
Tables.GetRelationships
Table.FromColumns
Table.FromPartitions
Table.PartitionValues
Table.FromRows
Table.PromoteHeaders
Table.RowCount
Table.ToRecords
Table.FromRecords
Table.Keys
Table.AddKey
Table.ReplaceKeys
Type.TableColumn
Type.TableRow
Type.TableKeys
Type.AddTableKey
Type.ReplaceTableKeys
Table.Column
Table.SelectColumns
Table.SelectRows
Table.RenameColumns
Table.TransformColumnNames
Table.ReorderColumns
Table.Skip
Table.First
Table.FirstN
Table.RemoveColumns
Table.Group
Table.Join
Table.AddJoinColumn
Table.NestedJoin
Table.AddIndexColumn
Table.FillDown
Table.TransformColumns
Table.TransformColumnTypes
Table.Sort
Table.Distinct
Table.ExpandRecordColumn
Table.AggregateTableColumn
Table.SingleRow
Table.Combine
Table.Pivot
Table.Unpivot
Table.UnpivotOtherColumns
Table.SelectRowsWithErrors
Table.RemoveRowsWithErrors
Table.ReplaceErrorValues
Table.ReplaceRelationshipIdentity
Table.FilterWithDataTable
Table.Split
Table.Buffer
JoinAlgorithm.Type
JoinAlgorithm.Dynamic
JoinAlgorithm.PairwiseHash
JoinAlgorithm.SortMerge
JoinAlgorithm.LeftHash
JoinAlgorithm.RightHash
JoinAlgorithm.LeftIndex
JoinAlgorithm.RightIndex
JoinSide.Type
JoinSide.Left
JoinSide.Right
RowExpression.From
RowExpression.Row
RowExpression.Column
ItemExpression.From
ItemExpression.Item
Table.ViewFunction
Uri.Combine
Uri.Parts
Uri.BuildQueryString
Uri.EscapeDataString
Variable.Value
Xml.Document
Xml.Tables
AccessControlEntry.Type
AccessControlEntry.ConditionContextType
AccessControlEntry.ConditionToIdentities
AccessControlKind.Type
AccessControlKind.Allow
AccessControlKind.Deny
IdentityProvider.Type
IdentityProvider.Default
Identity.Type
Identity.From
Identity.IsMemberOf
File.Contents
Folder.Contents
Folder.Files
Web.Contents
Soda.Feed
WebMethod.Type
WebMethod.Delete
WebMethod.Get
WebMethod.Head
WebMethod.Patch
WebMethod.Post
WebMethod.Put
WebAction.Request
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment