Power Query (informally known as "M") formula categories

Power Query (informally known as "M") formula categories

 

This topic applies to the Power Query Formula Language (informally known as "M") which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

The following tables describe the Power Query formula categories that can be used to manually create or modify queries. These formula functions can also be used in the Power BI Designer, in the Query view.

Constants

FunctionDescription
Number.NaNRepresents 0/0.
Number.NegativeInfinityRepresents -1/0.
Number.PositiveInfinityRepresents 1/0.
Number.EpsilonReturns the smallest possible number.
Number.EReturns 2.7182818284590451, the value of e up to 16 decimal digits.
Number.PIReturns 3.1415926535897931, the value for Pi up to 16 decimal digits.

Information

FunctionDescription
Number.IsNaNReturns true if a value is Number.NaN.
Number.IsEvenReturns true if a value is an even number.
Number.IsOddReturns true if a value is an odd number.

Conversion and formatting

FunctionDescription
Number.FromTextReturns a number value from a text value.
Number.ToTextReturns a text value from a number value.
Number.FromReturns a number value from a value.
Byte.FromReturns a 8-bit integer number value from the given value.
Int8.FromReturns a signed 8-bit integer number value from the given value.
Int16.FromReturns a 16-bit integer number value from the given value.
Int32.FromReturns a 32-bit integer number value from the given value.
Int64.FromReturns a 64-bit integer number value from the given value.
Single.FromReturns a Single number value from the given value.
Double.FromReturns a Double number value from the given value.
Decimal.FromReturns a decimal number value from the given value.
Currency.FromReturns a currency value from the given value.

Rounding

FunctionDescription
Number.RoundDownReturns the largest integer less than or equal to a number value.
Number.RoundUpReturns the larger integer greater than or equal to a number value.
Number.RoundTowardZeroReturns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0.
Number.RoundAwayFromZeroReturns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0.
Number.RoundReturns a nullable number (n) if value is an integer.

Operations

FunctionDescription
Number.AbsReturns the absolute value of a number.
Number.SignReturns 1 for positive numbers, -1 for negative numbers or 0 for zero.
Number.IntegerDivideDivides two numbers and returns the whole part of the resulting number.
Number.ModDivides two numbers and returns the remainder of the resulting number.
Number.PowerReturns a number raised by a power.
Number.SqrtReturns the square root of a number.
Number.ExpReturns a number representing e raised to a power.
Number.LnReturns the natural logarithm of a number.
Number.LogReturns the logarithm of a number to the base.
Number.Log10Returns the base-10 logarithm of a number.
Number.FactorialReturns the factorial of a number.
Number.CombinationsReturns the number of combinations of a given number of items for the optional combination size.
Number.PermutationsReturns the number of total permutatons of a given number of items for the optional permutation size.

Random

FunctionDescription
Number.RandomReturns a random fractional number between 0 and 1.
Number.RandomBetweenReturns a random number between the two given number values.

Trigonometry

FunctionDescription
Number.AcosReturns the arccosine of a number.
Number.AsinReturns the arcsine of a number.
Number.AtanReturns the arctangent of a number.
Number.Atan2Returns the arctangent of the division of two numbers.
Number.CosReturns the cosine of a number.
Number.CoshReturns the hyperbolic cosine of a number.
Number.SinReturns the sine of a number.
Number.SinhReturns the hyperbolic sine of a number.
Number.TanReturns the tangent of a number.
Number.TanhReturns the hyperbolic tangent of a number.

Bytes

FunctionDescription
Number.BitwiseAndReturns the result of a bitwise AND operation on the provided operands.
Number.BitwiseNotReturns the result of a bitwise NOT operation on the provided operands.
Number.BitwiseOrReturns the result of a bitwise OR operation on the provided operands.
Number.BitwiseShiftLeftReturns the result of a bitwise shift left operation on the operands.
Number.BitwiseShiftRightReturns the result of a bitwise shift right operation on the operands.
Number.BitwiseXorReturns the result of a bitwise XOR operation on the provided operands.

Information

FunctionDescription
Text.LengthReturns the number of characters in a text value.

Text Comparisons

FunctionDescription
Character.FromNumberReturns a number to its character value.
Character.ToNumberReturns a character to its number value.
Text.FromReturns the text representation of a number, date, time, datetime, datetimezone, logical, duration or binary value. If a value is null, Text.From returns null. The optional culture parameter is used to format the text value according to the given culture.
Text.FromBinaryDecodes data from a binary value in to a text value using an encoding.
Text.NewGuidReturns a Guid value as a text value.
Text.ToBinaryEncodes a text value into binary value using an encoding.
Text.ToListReturns a list of characters from a text value.
Value.FromTextDecodes a value from a textual representation, value, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a DateTime value, a Duration value, or a text value. The empty text value is interpreted as a null value.

Extraction

FunctionDescription
Text.AtReturns a character starting at a zero-based offset.
Text.RangeReturns a number of characters from a text value starting at a zero-based offset and for count number of characters.
Text.StartReturns the count of characters from the start of a text value.
FunctionDescription
Text.EndReturns the number of characters from the end of a text value.

Modification

FunctionDescription
Text.InsertReturns a text value with newValue inserted into a text value starting at a zero-based offset.
Text.RemoveRemoves all occurrences of a character or list of characters from a text value. The removeChars parameter can be a character value or a list of character values.
Text.RemoveRangeRemoves count characters at a zero-based offset from a text value.
Text.ReplaceReplaces all occurrences of a substring with a new text value.
Text.ReplaceRangeReplaces length characters in a text value starting at a zero-based offset with the new text value.

Membership

FunctionDescription
Text.ContainsReturns true if a text value substring was found within a text value string; otherwise, false.
Text.EndsWithReturns a logical value indicating whether a text value substring was found at the end of a string.
Text.PositionOfReturns the first occurrence of substring in a string and returns its position starting at startOffset.
Text.PositionOfAnyReturns the first occurrence of a text value in list and returns its position starting at startOffset.
Text.StartsWithReturns a logical value indicating whether a text value substring was found at the beginning of a string.

Transformations

FunctionDescription
Text.CleanReturns the original text value with non-printable characters removed.
Text.CombineReturns a text value that is the result of joining all text values with each value separated by a separator.
Text.LowerReturns the lowercase of a text value.
Text.PadEndReturns a text value padded at the end with pad to make it at least length characters.
Text.PadStartReturns a text value padded at the beginning with pad to make it at least length characters. If pad is not specified, whitespace is used as pad.
Text.ProperReturns a text value with first letters of all words converted to uppercase.
Text.RepeatReturns a text value composed of the input text value repeated a number of times.
Text.SplitReturns a list containing parts of a text value that are delimited by a separator text value.
Text.SplitAnyReturns a list containing parts of a text value that are delimited by any separator text values.
Text.TrimRemoves any occurrences of characters in trimChars from text.
Text.TrimEndRemoves any occurrences of the characters specified in trimChars from the end of the original text value.
Text.TrimStartRemoves any occurrences of the characters in trimChars from the start of the original text value.
Text.UpperReturns the uppercase of a text value.
FunctionDescription
Logical.FromReturns a logical value from a value.
Logical.FromTextReturns a logical value of true or false from a text value.
Logical.ToTextReturns a text value from a logical value.
FunctionDescription
Date.AddDaysReturns a Date/DateTime/DateTimeZone value with the day portion incremented by the number of days provided. It also handles incrementing the month and year potions of the value as appropriate.
Date.AddMonthsReturns a DateTime value with the month portion incremented by n months.
Date.AddQuartersReturns a Date/DateTime/DateTimeZone value incremented by the number of quarters provided. Each quarter is defined as a duration of three months. It also handles incrementing the year potion of the value as appropriate.
Date.AddWeeksReturns a Date/DateTime/DateTimeZone value incremented by the number of weeks provided. Each week is defined as a duration of seven days. It also handles incrementing the month and year potions of the value as appropriate.
Date.AddYearsReturns a DateTime value with the year portion incremented by n years.
Date.DayReturns the day for a DateTime value.
Date.DayOfWeekReturns a number between 0 and 6 representing the day of the week from a DateTime value.
Date.DayOfYearReturns a number that represents the day of the year from a DateTime value.
Date.DaysInMonthReturns the number of days in the month from a DateTime value.
Date.EndOfDayReturns a DateTime value for the end of the day.
Date.EndOfMonthReturns a DateTime value for the end of the month.
Date.EndOfQuarterReturns a Date/DateTime/DateTimeZone value representing the end of the quarter. The date and time portions are reset to their terminating values for the quarter. The timezone information is persisted.
Date.EndOfWeekReturns a DateTime value for the end of the week.
Date.EndOfYearReturns a DateTime value for the end of the year.
Date.FromReturns a date value from a value.
Date.FromTextReturns a Date value from a set of date formats and culture value.
Date.IsInCurrentMonthReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current month, as determined by the current date and time on the system.
Date.IsInCurrentQuarterReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current quarter, as determined by the current date and time on the system.
Date.IsInCurrentWeekReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current week, as determined by the current date and time on the system.
Date.IsInCurrentYearReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current year, as determined by the current date and time on the system.
Date.IsInNextMonthReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next month, as determined by the current date and time on the system.
Date.IsInNextQuarterReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next quarter, as determined by the current date and time on the system.
Date.IsInNextWeekReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next week, as determined by the current date and time on the system.
Date.IsInNextYearReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next year, as determined by the current date and time on the system.
Date.IsInPreviousMonthReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous month, as determined by the current date and time on the system.
Date.IsInPreviousQuarterReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous quarter, as determined by the current date and time on the system.
Date.IsInPreviousWeekReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous week, as determined by the current date and time on the system.
Date.IsInPreviousYearReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous year, as determined by the current date and time on the system.
Date.IsInYearToDateReturns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred in the period starting January 1st of the current year and ending on the current day, as determined by the current date and time on the system.
Date.IsLeapYearReturns a logical value indicating whether the year portion of a DateTime value is a leap year.
Date.MonthReturns the month from a DateTime value.
Date.QuarterOfYearReturns a number between 1 and 4 for the quarter of the year from a DateTime value.
Date.StartOfDayReturns a DateTime value for the start of the day.
Date.StartOfMonthReturns a DateTime value representing the start of the month.
Date.StartOfQuarterReturns a DateTime value representing the start of the quarter.
Date.StartOfWeekReturns a DateTime value representing the start of the week.
Date.StartOfYearReturns a DateTime value representing the start of the year.
Date.ToRecordReturns a record containing parts of a Date value.
Date.ToTextReturns a text value from a Date value.
Date.WeekOfMonthReturns a number for the count of week in the current month.
Date.WeekOfYearReturns a number for the count of week in the current year.
Date.YearReturns the year from a DateTime value.
FunctionDescription
Time.EndOfHourReturns a DateTime value from the end of the hour.
Time.FromReturns a time value from a value.
Time.FromTextReturns a Time value from a set of date formats.
Time.HourReturns an hour value from a DateTime value.
Time.MinuteReturns a minute value from a DateTime value.
Time.SecondReturns a second value from a DateTime value
Time.StartOfHourReturns the first value of the hour from a time value.
Time.ToRecordReturns a record containing parts of a Date value.
Time.ToTextReturns a text value from a Time value.
FunctionDescription
DateTime.AddZoneAdds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.
DateTime.DateReturns a date part from a DateTime value
DateTime.FixedLocalNowReturns a DateTime value set to the current date and time on the system.
DateTime.FromReturns a datetime value from a value.
DateTime.FromFileTimeReturns a DateTime value from the supplied number.
DateTime.FromTextReturns a DateTime value from a set of date formats and culture value.
DateTime.LocalNowReturns a datetime value set to the current date and time on the system.
DateTime.TimeReturns a time part from a DateTime value.
DateTime.ToRecordReturns a record containing parts of a DateTime value.
DateTime.ToTextReturns a text value from a DateTime value.
FunctionDescription
DateTimeZone.FixedLocalNowReturns a DateTimeZone value set to the current date, time, and timezone offset on the system.
DateTimeZone.FixedUtcNowReturns the current date and time in UTC (the GMT timezone).
DateTimeZone.FromReturns a datetimezone value from a value.
DateTimeZone.FromFileTimeReturns a DateTimeZone from a number value.
DateTimeZone.FromTextReturns a DateTimeZone value from a set of date formats and culture value.
DateTimeZone.LocalNowReturns a DateTime value set to the current system date and time.
DateTimeZone.RemoveZoneReturns a datetime value with the zone information removed from the input datetimezone value.
DateTimeZone.SwitchZoneChanges the timezone information for the input DateTimeZone.
DateTimeZone.ToLocalReturns a DateTime value from the local time zone.
DateTimeZone.ToRecordReturns a record containing parts of a DateTime value.
DateTimeZone.ToTextReturns a text value from a DateTime value.
DateTimeZone.ToUtcReturns a DateTime value to the Utc time zone.
DateTimeZone.UtcNowReturns a DateTime value set to the current system date and time in the Utc timezone.
DateTimeZone.ZoneHoursReturns a time zone hour value from a DateTime value.
DateTimeZone.ZoneMinutesReturns a time zone minute value from a DateTime value.
FunctionDescription
Duration.DaysReturns the day component of a Duration value.
Duration.FromReturns a duration value from a value.
Duration.FromTextReturns a Duration value from a text value.
Duration.HoursReturns an hour component of a Duration value.
Duration.MinutesReturns a minute component of a Duration value.
Duration.SecondsReturns a second component of a Duration value.
Duration.ToRecordReturns a record with parts of a Duration value.
Duration.TotalDaysReturns the total magnitude of days from a Duration value.
Duration.TotalHoursReturns the total magnitude of hours from a Duration value.
Duration.TotalMinutesReturns the total magnitude of minutes from a Duration value.
Duration.TotalSecondsReturns the total magnitude of seconds from a duration value.
Duration.ToTextReturns a text value from a Duration value.

Information

FunctionDescription
Record.FieldCountReturns the number of fields in a record.
Record.HasFieldsReturns true if the field name or field names are present in a record.

Transformations

FunctionDescription
Record.AddFieldAdds a field from a field name and value.
Record.CombineCombines the records in a list.
Record.TransformFieldsTransforms fields by applying transformOperations. For more more information about values supported by transformOperations, see Parameter Values.
Record.RemoveFieldsReturns a new record that reorders the given fields with respect to each other. Any fields not specified remain in their original locations.
Record.ReorderFieldsReturns a new record that reorders fields relative to each other. Any fields not specified remain in their original locations. Requires two or more fields.
Record.RenameFieldsReturns a new record that renames the fields specified. The resultant fields will retain their original order. This function supports swapping and chaining field names. However, all target names plus remaining field names must constitute a unique set or an error will occur.

Selection

FunctionDescription
Record.FieldReturns the value of the given field. This function can be used to dynamically create field lookup syntax for a given record. In that way it is a dynamic verison of the record[field] syntax.
Record.FieldValuesReturns a list of field values in order of the record's fields.
Record.FieldNamesReturns a list of field names in order of the record's fields.
Record.FieldOrDefaultReturns the value of a field from a record, or the default value if the field does not exist.
Record.SelectFieldsReturns a new record that contains the fields selected from the input record. The original order of the fields is maintained.

Serialization

FunctionDescription
Record.ToTableReturns a table of records containing field names and values from an input record.
Record.FromTableReturns a record from a table of records containing field names and values.
Record.ToTableReturns a record from a list of field values and a set of field names.

Parameter Values

The following type definitions are used to describe the parameter values that are referenced in Record functions above.

MissingField optionMissingField.Error = 0
MissingField.Ignore = 1
MissingField.UseNull = 2
Transform operationsTransform operations can be specified by either of the following values:

A list value of two items, first item being the field name and the second item being the transformation function applied to that field to produce a new value.

A list of transformations can be provided by providing a list value, and each item being the list value of 2 items as described above.

For examples, see description of Record.TransformFields
Rename operationsRename operations for a record can be specified as either of:

A single rename operation, which is represented by a list of two field names, old and new.

 

For examples, see description of Record.RenameFields.

These functions deal with list of values.

Information

FunctionDescription
List.CountReturns the number of items in a list.
List.NonNullCountReturns the number of items in a list excluding null values
List.IsEmptyReturns whether a list is empty.

Selection

FunctionDescription
List.AlternateReturns a list with the items alternated from the original list based on a count, optional repeatInterval, and an optional offset.
List.DistinctFilters a list down by removing duplicates. An optional equation criteria value can be specified to control equality comparison. The first value from each equality group is chosen.
List.IsDistinctReturns whether a list is distinct.
List.SelectSelects the items that match a condition.
List.FirstReturns the first value of the list or the specified default if empty. Returns the first item in the list, or the optional default value, if the list is empty. If the list is empty and a default value is not specified, the function returns.
List.FirstNReturns the first set of items in the list by specifying how many items to return or a qualifying condition provided by countOrCondition.
List.InsertRangeInserts items from values at the given index in the input list.
List.LastReturns the last set of items in the list by specifying how many items to return or a qualifying condition provided by countOrCondition.
List.LastNReturns the last set of items in a list by specifying how many items to return or a qualifying condition.
List.MatchesAllReturns true if all items in a list meet a condition.
List.MatchesAnyReturns true if any item in a list meets a condition.
List.PositionsReturns a list of positions for an input list.
List.RangeReturns a count items starting at an offset.
List.SingleReturns the single item of the list or throws an Expression.Error if the list has more than one item.
List.SingleOrDefaultReturns a single item from a list.
List.SkipSkips the first item of the list. Given an empty list, it returns an empty list. This function takes an optional parameter countOrCondition to support skipping multiple values.
List.BufferBuffers the list in memory. The result of this call is a stable list, which means it will have a determinimic count, and order of items.
List.FindTextSearches a list of values, including record fields, for a text value.

Transformation functions

FunctionDescription
List.AccumulateAccumulates a result from the list. Starting from the initial value seed this function applies the accumulator function and returns the final result.
List.CombineMerges a list of lists into single list.
List.TransformPerforms the function on each item in the list and returns the new list.
List.TransformManyReturns a list whose elements are projected from the input list.
List.RepeatReturns a list that repeats the contents of an input list count times.
List.ReplaceRangeReturns a list that replaces count values in a list with a replaceWith list starting at an index.
List.RemoveRangeReturns a list that removes count items starting at offset. The default count is 1.
List.RemoveFirstNReturns a list with the specified number of elements removed from the list starting at the first element. The number of elements removed depends on the optional countOrCondition parameter.
List.RemoveLastNReturns a list with the specified number of elements removed from the list starting at the last element. The number of elements removed depends on the optional countOrCondition parameter.
List.ReverseReturns a list that reverses the items in a list.
List.RemoveMatchingItemsRemoves all occurrences of the given values in the list.
List.RemoveItemsRemoves items from list1 that are present in list2, and returns a new list.
List.RemoveNullsRemoves null values from a list.
List.ReplaceMatchingItemsReplaces occurrences of existing values in the list with new values using the provided equationCriteria. Old and new values are provided by the replacements parameters. An optional equation criteria value can be specified to control equality comparisons. For details of replacement operations and equation criteria, see Parameter Values.
List.ReplaceValueSearches a list of values for the value and replaces each occurrence with the replacement value.

Membership functions

Since all values can be tested for equality, these functions can operate over heterogeneous lists.

FunctionDescription
List.ContainsReturns true if a value is found in a list.
List.ContainsAllReturns true if all items in values are found in a list.
List.ContainsAnyReturns true if any item in values is found in a list.
List.PositionOfFinds the first occurrence of a value in a list and returns its position.
List.PositionOfAnyFinds the first occurrence of any value in values and returns its position.
List.AnyTrueReturns true if any expression in a list in true
List.AllTrueReturns true if all expressions in a list are true

Set operations

FunctionDescription
List.DifferenceReturns the items in list 1 that do not appear in list 2. Duplicate values are supported.
List.IntersectReturns a list from a list of lists and intersects common items in individual lists. Duplicate values are supported.
List.UnionReturns a list from a list of lists and unions the items in the individual lists. The returned list contains all items in any input lists. Duplicate values are matched as part of the Union.

Ordering

Ordering functions perform comparisons. All values that are compared must be comparable with each other. This means they must all come from the same datatype (or include null, which always compares smallest). Otherwise, an Expression.Error is thrown.

Comparable data types

Number  
Duration  
DateTime  
Text  
Logical  
Null  

FunctionDescription
List.SortReturns a sorted list using comparison criterion.
List.MaxReturns the maximum item in a list, or the optional default value if the list is empty.
List.MaxNReturns the maximum values in the list. After the rows are sorted, optional parameters may be specified to further filter the result
List.MinReturns the minimum item in a list, or the optional default value if the list is empty.
List.MinNReturns the minimum values in a list.
List.MedianReturns the median item from a list.

Averages

These functions operate over homogeneous lists of Numbers, DateTimes, and Durations.

FunctionDescription
List.AverageReturns an average value from a list in the datatype of the values in the list.
List.StandardDeviationReturns the standard deviation from a list of values. List.StandardDeviation performs a sample based estimate. The result is a number for numbers, and a duration for DateTimes and Durations.
List.ModeReturns an item that appears most commonly in a list.
List.ModesReturns all items that appear with the same maximum frequency.

Addition

These functions work over homogeneous lists of Numbers or Durations.

FunctionDescription
List.SumReturns the sum from a list.

Numerics

These functions only work over numbers.

FunctionDescription
List.CovarianceReturns the covariance from two lists as a number.
List.ProductReturns the product from a list of numbers.

Generators

These functions generate list of values.

FunctionDescription
List.DateTimesReturns a list of datetime values from size count, starting at start and adds an increment to every value.
List.DatesReturns a list of date values from size count, starting at start and adds an increment to every value.
List.DateTimeZonesReturns a list of of datetimezone values from size count, starting at start and adds an increment to every value.
List.DurationsReturns a list of durations values from size count, starting at start and adds an increment to every value.
List.GenerateGenerates a list from a value function, a condition function, a next function, and an optional transformation function on the values.
List.NumbersReturns a list of numbers from size count starting at initial, and adds an increment. The increment defaults to 1.
List.RandomReturns a list of count random numbers, with an optional seed parameter.

Occurrence specification

Occurrence.First = 0  
Occurrence.Last = 1  
Occurrence.All = 2  

Sort order

Order.Ascending = 0  
Order.Descending = 1  

Equation criteria

Equation criteria for list values can be specified as either a

A function value that is either

A key selector that determines the value in the list to apply the equality criteria, or

A comparer function that is used to specify the kind of comparison to apply. Built in comparer functions can be specified, see section for Comparer functions.

A list value which has

Exactly two items

The first element is the key selector as specified above

The second element is a comparer as specified above.

For more information and examples, see List.Distinct.

Comparison criteria

Comparison criterion can be provided as either of the following values:

A number value to specify a sort order. For more information, see sort order in Parameter values.

To compute a key to be used for sorting, a function of 1 argument can be used.

To both select a key and control order, comparison criterion can be a list containing the key and order.

To completely control the comparison, a function of 2 arguments can be used that returns -1, 0, or 1 given the relationship between the left and right inputs. Value.Compare is a method that can be used to delegate this logic.

For more information and examples, see List.Sort.

Replacement operations

Replacement operations are specified by a list value, each item of this list must be

A list value of exactly two items

Fist item is the old value in the list, to be replaced

Second item is the new which should replace all occurrences of the old value in the list

These functions deal with Table values.

Table construction

FunctionDescription
Table.FromRowsCreates a table from the list where each element of the list is a list that contains the column values for a single row.
Table.FromListConverts a list into a table by applying the specified splitting function to each item in the list.
Table.FromColumnsReturns a table from a list containing nested lists with the column names and values.
Table.FromRecordsReturns a table from a list of records.
Table.FromValueReturns a table with a column containing the provided value or list of values.

Conversions

FunctionDescription
Table.ToColumnsReturns a list of nested lists each representing a column of values in the input table.
Table.ToListReturns a table into a list by applying the specified combining function to each row of values in a table.
Table.ToRecordsReturns a list of records from an input table.
Table.ToRowsReturns a nested list of row values from an input table.

Information

FunctionDescription
Table.IsEmptyReturns true if the table does not contain any rows.
Table.RowCountReturns the number of rows in a table.
Table.ColumnCountReturns the number of columns in a table.
Table.PartitionValuesReturns information about how a table is partitioned.
Tables. GetRelationshsipsReturns the relationships among a set of tables.

Row operations

FunctionDescription
Table.AlternateRowsReturns a table containing an alternating pattern of the rows from a table.
Table.CombineReturns a table that is the result of merging a list of tables. The tables must all have the same row type structure.
Table.FirstNReturns the first row(s) of a table, depending on the countOrCondition parameter.
Table.FirstReturns the first row from a table.
Table.InsertRowsReturns a table with the list of rows inserted into the table at an index. Each row to insert must match the row type of the table..
Table.LastNReturns the last row(s) from a table, depending on the countOrCondition parameter.
Table.LastReturns the last row of a table.
Table.MatchesAllRowsReturns true if all of the rows in a table meet a condition.
Table.MatchesAnyRowsReturns true if any of the rows in a table meet a condition.
Table.PartitionPartitions the table into a list of groups number of tables, based on the value of the column of each row and a hash function. The hash function is applied to the value of the column of a row to obtain a hash value for the row. The hash value modulo groups determines in which of the returned tables the row will be placed.
Table.FromPartitionsReturns a table that is the result of combining a set of partitioned tables into new columns. The type of the column can optionally be specified, the default is any.
Table.RangeReturns the specified number of rows from a table starting at an offset.
Table.RemoveRowsReturns a table with the specified number of rows removed from the table starting at an offset.
Table.RemoveFirstNReturns a table with the specified number of rows removed from the table starting at the first row. The number of rows removed depends on the optional countOrCondition parameter.
Table.RemoveLastNReturns a table with the specified number of rows removed from the table starting at the last row. The number of rows removed depends on the optional countOrCondition parameter.
Table.RemoveRowsWithErrorsReturns a table with all rows removed from the table that contain an error in at least one of the cells in a row.
Table.RepeatReturns a table containing the rows of the table repeated the count number of times.
Table.ReplaceRowsReturns a table where the rows beginning at an offset and continuing for count are replaced with the provided rows.
Table.ReverseRowsReturns a table with the rows in reverse order.
Table.SelectRowsReturns a table containing only the rows that match a condition.
Table.SelectRowsWithErrorsReturns a table with only the rows from table that contain an error in at least one of the cells in a row.
Table.SingleRowReturns a single row from a table.
Table.SkipReturns a table that does not contain the first row or rows of the table.
Table.FindTextReturns a table containing only the rows that have the specified text within one of their cells or any part thereof.

Column operations

FunctionDescription
Table.ColumnReturns the values from a column in a table.
Table.ColumnNamesReturns the names of columns from a table.
Table.ColumnsOfTypeReturns a list with the names of the columns that match the specified types.
Table.HasColumnsReturns true if a table has the specified column or columns.
Table.PrefixColumnsReturns a table where the columns have all been prefixed with a text value.
Table.PromoteHeadersPromotes the first row of the table into its header or column names.
Table.DemoteHeadersDemotes the header row down into the first row of a table.
Table.RemoveColumnsReturns a table without a specific column or columns.
Table.ReorderColumnsReturns a table with specific columns in an order relative to one another.
Table.RenameColumnsReturns a table with the columns renamed as specified.
Table.SelectColumnsReturns a table that contains only specific columns.
Table.PivotGiven a table and attribute column containing pivotValues, creates new columns for each of the pivot values and assigns them values from the valueColumn. An optional aggregationFunction can be provided to handle multiple occurrence of the same key value in the attribute column.
Table.UnpivotGiven a list of table columns, transforms those columns into attribute-value pairs.
Table.UnpivotOtherColumnsTranslates all columns other than a specified set into attribute-value pairs, combined with the rest of the values in each row.

Transformation

Parameters for Group options

GroupKind.Global = 0  
GroupKind.Local = 1  

Parameters for Join kinds

JoinKind.Inner = 0  
JoinKind.LeftOuter = 1  
JoinKind.RightOuter = 2  
JoinKind.FullOuter = 3  
JoinKind.LeftAnti = 4  
JoinKind.RightAnti = 5  

Join Algorithm

The following JoinAlgorithm values can be specified to Table.Join

JoinAlgorithm.Dynamic  = 0  
JoinAlgorithm.PairwiseHash = 1  
JoinAlgorithm.SortMerge = 2  
JoinAlgorithm.LeftHash = 3  
JoinAlgorithm.RightHash  = 4  
JoinAlgorithm.LeftIndex = 5  
JoinAlgorithm.RightIndex = 6  

Example data

The following tables are used by the examples in this section.

Customers table

Customers = Table.FromRecords({  
  
  [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
  [CustomerID = 2, Name = "Jim", Phone = "987-6543"],  
  
  [CustomerID = 3, Name = "Paul", Phone = "543-7890"],  
  
  [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
  
}  
  

Orders table

Orders = Table.FromRecords({  
  
  [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0],  
  
  [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0],  
  
  [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0],  
  
  [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0],  
  
  [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0],  
  
  [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0],  
  
  [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25],  
  
  [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0],  
  
  [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]  
  
})  
  

FunctionDescription
Table.AddColumnAdds a column named newColumnName to a table.
Table.AddIndexColumnReturns a table with a new column with a specific name that, for each row, contains an index of the row in the table.
Table.AddJoinColumnPerforms a nested join between table1 and table2 from specific columns and produces the join result as a newColumnName column for each row of table1.
Table.AddKeyAdd a key to table.
Table.AggregateTableColumnAggregates tables nested in a specific column into multiple columns containing aggregate values for those tables.
Table.ExpandListColumnGiven a column of lists in a table, create a copy of a row for each value in its list.
Table.ExpandRecordColumnExpands a column of records into columns with each of the values.
Table.ExpandTableColumnExpands a column of records or a column of tables into multiple columns in the containing table.
Table.FillDownReplaces null values in the specified column or columns of the table with the most recent non-null value in the column.
Table.FillUpReturns a table from the table specified where the value of the next cell is propagated to the null values cells above in the column specified.
Table.GroupGroups table rows by the values of key columns for each row.
Table.JoinJoins the rows of table1 with the rows of table2 based on the equality of the values of the key columns selected by table1, key1 and table2, key2.
Table.NestedJoinJoins the rows of the tables based on the equality of the keys. The results are entered into a new column.
Table.KeysReturns a list of key column names from a table.
Table.ReplaceKeysReturns a new table with new key information set in the keys argument.
Table.CombineColumnsTable.CombineColumns merges columns using a combiner function to produce a new column. Table.CombineColumns is the inverse of Table.SplitColumns.
Table.SplitColumnReturns a new set of columns from a single column applying a splitter function to each value.
Table.TransformColumnsTransforms columns from a table using a function.
Table.TransformColumnTypesTransforms the column types from a table using a type.
Table.TransformRowsTransforms the rows from a table using a transform function.
Table.TransposeReturns a table with columns converted to rows and rows converted to columns from the input table.
Table.ReplaceValueReplaces oldValue with newValue in specific columns of a table, using the provided replacer function, such as text.Replace or Value.Replace.
Table.ReplaceErrorValuesReplaces the error values in the specified columns with the corresponding specified value.

Membership

Parameters for membership checks

Occurrence specification

Occurrence.First  = 0  
Occurrence.Last   = 1  
Occurrence.All    = 2  

FunctionDescription
Table.ContainsDetermines whether the a record appears as a row in the table.
Table.ContainsAllDetermines whether all of the specified records appear as rows in the table.
Table.ContainsAnyDetermines whether any of the specified records appear as rows in the table.
Table.DistinctRemoves duplicate rows from a table, ensuring that all remaining rows are distinct.
Table.IsDistinctDetermines whether a table contains only distinct rows.
Table.PositionOfDetermines the position or positions of a row within a table.
Table.PositionOfAnyDetermines the position or positions of any of the specified rows within the table.
Table.RemoveMatchingRowsRemoves all occurrences of rows from a table.
Table.ReplaceMatchingRowsReplaces specific rows from a table with the new rows.

Ordering

Example data

The following tables are used by the examples in this section.

Employees table

Employees = Table.FromRecords(  
  
    {[Name="Bill",   Level=7,  Salary=100000],  
  
     [Name="Barb",   Level=8,  Salary=150000],  
  
     [Name="Andrew", Level=6,  Salary=85000],  
  
     [Name="Nikki",  Level=5,  Salary=75000],  
  
     [Name="Margo",  Level=3,  Salary=45000],  
  
     [Name="Jeff",   Level=10, Salary=200000]},  
  
type table [  
  
    Name = text,  
  
    Level = number,  
  
    Salary = number  
  
])  
  

FunctionDescription
Table.MaxNReturns the largest N rows from a table. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result.
Table.MaxReturns the largest row or rows from a table using a comparisonCriteria.
Table.MinNReturns the smallest N rows in the given table. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result.
Table.MinReturns the smallest row or rows from a table using a comparisonCriteria.
Table.SortSorts the rows in a table using a comparisonCriteria or a default ordering if one is not specified.

Other

FunctionDescription
Table.BufferBuffers a table into memory, isolating it from external changes during evaluation.

Parameter Values

Naming output columns

This parameter is a list of text values specifying the column names of the resulting table. This parameter is generally used in the Table construction functions, such as Table.FromRows and Table.FromList.

Comparison criteria

Comparison criterion can be provided as either of the following values:

A number value to specify a sort order. See sort order in the parameter values section above.

To compute a key to be used for sorting, a function of 1 argument can be used.

To both select a key and control order, comparison criterion can be a list containing the key and order.

To completely control the comparison, a function of 2 arguments can be used that returns -1, 0, or 1 given the relationship between the left and right inputs. Value.Compare is a method that can be used to delegate this logic.

For examples, see description of Table.Sort.

Count or Condition critieria

This criteria is generally used in ordering or row operations. It determines the number of rows returned in the table and can take two forms, a number or a condition:

A number indicates how many values to return inline with the appropriate function

If a condition is specified, the rows containing values that initially meet the condition is returned. Once a value fails the condition, no further values are considered.

See Table.FirstN or Table.MaxN.

Handling of extra values

This is used to indicate how the function should handle extra values in a row. This parameter is specified as a number, which maps to the options below.

ExtraValues.List = 0  
ExtraValues.Error = 1  
ExtraValues.Ignore = 2  

For more information, see Table.FromList.

Missing column handling

This is used to indicate how the function should handle missing columns. This parameter is specified as a number, which maps to the options below.

MissingField.Error = 0;  
MissingField.Ignore = 1;  
MissingField.UseNull = 2;  

This is used in column or transformation operations. For Examples, see Table.TransformColumns.

Sort Order

This is used to indicate how the results should be sorted. This parameter is specified as a number, which maps to the options below.

Order.Ascending = 0  
Order.Descending = 1  

Equation criteria

Equation criteria for tables can be specified as either a

A function value that is either

A key selector that determines the column in the table to apply the equality criteria, or

A comparer function that is used to specify the kind of comparison to apply. Built in comparer functions can be specified, see section for Comparer functions.

A list of the columns in the table to apply the equality criteria

For examples, look at description for Table.Distinct.

FunctionDescription
Value.CompareReturns 1, 0, or -1 based on value1 being greater than, equal to, or less than the value2. An optional comparer function can be provided.
Value.EqualsReturns whether two values are equal.
Value.NullableEqualsReturns a logical value or null based on two values .

Arithmetic operations

FunctionDescription
Value.Add
Value.Subtract
Value.Divide
Value.Multiply

Parameter types

TypeDescription
Value.AsValue.As is the function corresponding to the as operator in the formula language. The expression value as type asserts that the value of a value argument is compatible with type as per the is operator. If it is not compatible, an error is raised.
Value.IsValue.Is is the function corresponding to the is operator in the formula language. The expression value is type returns true if the ascribed type of vlaue is compatible with type, and returns false if the ascribed type of value is incompatible with type.
Value.ReplaceTypeA value may be ascribed a type using Value.ReplaceType. Value.ReplaceType either returns a new value with the type ascribed or raises an error if the new type is incompatible with the value’s native primitive type. In particular, the function raises an error when an attempt is made to ascribe an abstract type, such as any. When replacing a the type of a record, the new type must have the same number of fields, and the new fields replace the old fields by ordinal position, not by name. Similarly, when replacing the type of a table, the new type must have the same number of columns, and the new columns replace the old columns by ordinal position.
Value.TypeThe ascribed type of a value may be obtained using Value.Type.
FunctionDescription
Value.MetadataReturns a record containing the input’s metadata.
Value.RemoveMetadataRemoves the metadata on the value and returns the original value.
Value.ReplaceMetadataReplaces the metadata on a value with the new metadata record provided and returns the original value with the new metadata attached.

The following deals with external data.

Return values

Functions in this section access data and return table values. Most of these functions return a table value that is called a navigation table. A navigation table is a two column table. The first column contains the name of an item and the corresponding second column contains the value of that item. This shape is primarily used by the Power Query user interface to provide navigation experience over the potentially large hierarchical data returned.

FunctionDescription
Access.DatabaseReturns a structural representation of an Microsoft Access database. The database argument is The return value is a record, where each field represents a table in the Access database.
ActiveDirectory.DomainsReturns a table with Domain information available in the current domain or optional Active Directory forest.
Marketplace.SubscriptionsReturns feeds offered by the Microsoft Azure DataMarket subscribed by the current user as a table.
Csv.DocumentReturns the contents of a CSV document as a table using the specified encoding.
Excel.WorkbookReturns a table representing sheets in the given excel workbook.
Excel.CurrentWorkbookReturns the tables in the current Excel workbook
Exchange.ContentsReturns a table of contents from a Microsoft Exchange account.
Facebook.GraphReturns a table containing content from the Facebook graph .
File.ContentsReturns the binary contents of the file located at a path.
Folder.ContentsReturns a table containing the properties and contents of the files and folders found at path.
Folder.FilesReturns a table containing a row for each file found at a folder path, and subfolders. Each row contains properties of the folder or file and a link to its content.
Hdfs.ContentsReturns a table containing a row for each folder and file found at the folder url, {0}, from a Hadoop file system. Each row contains properties of the folder or file and a link to its content.
Hdfs.FilesReturns a table containing a row for each file found at the folder url, {0}, and subfolders from a Hadoop file system. Each row contains properties of the file and a link to its content.
Json.DocumentReturns the contents of a JSON document. The contents may be directly passed to the function as text, or it may be the binary value returned by a function like File.Contents.
OData.FeedReturns a table of OData feeds offered by an OData serviceUri.
Soda.FeedReturns the resulting table of a CSV file that can be accessed using the SODA 2.0 API. The URL must point to a valid SODA-compliant source that ends in a .csv extension.
Sql.DatabasesReturns a table with references to databases located on a SQL Server instance. Returns a navigation table.
Sql.DatabaseReturns a table containing SQL tables located on a SQL Server instance database.
Oracle.DatabaseReturns a table with data relating to the tables in the specified Oracle Database.
DB2.DatabaseReturns a table with data relating to the tables in the specified DB2 Database.
MySQL.DatabaseReturns a table with data relating to the tables in the specified MySQL Database.
Sybase.DatabaseReturns a table with data relating to the tables in the specified Sybase Database.
SharePoint.ContentsReturns a table containing a row for each folder and document found at the SharePoint site url. Each row contains properties of the folder or file and a link to its content.
SharePoint.FilesReturns a table containing a row for each document found at the SharePoint site url, and subfolders. Each row contains properties of the folder or file and a link to its content.
SharePoint.TablesReturns a table containing the result of a SharePoint List as an OData feed.
Teradata.DatabaseReturns a table with data relating to the tables in the specified Teradata Database.
PostgreSQL.DatabaseReturns a table with data relating to the tables in the specified PostgreSQL Database.
Web.ContentsReturns the contents downloaded from a web url as a binary value.
Web.PageReturns the contents of an HTML webpage as a table.
Xml.DocumentReturns the contents of an XML document as a hierarchical table (list of records).
Xml.TablesReturns the contents of an XML document as a nested collection of flattened tables.
HdInsight.ContainersReturns a navigational table containing all containers found in the HDInsight account. Each row has the container name and table containing its files.
HdInsight.ContentsReturns a navigational table containing all containers found in the HDInsight account. Each row has the container name and table containing its files.
HdInsight.FilesReturns a table containing a row for each folder and file found at the container URL, and subfolders from an HDInsight account. Each row contains properties of the file/folder and a link to its content.
AzureStorage.BlobsReturns a navigational table containing all containers found in the Azure Storage account. Each row has the container name and a link to the container blobs.
AzureStorage.TablesReturns a navigational table containing a row for each table found at the account URL from an Azure storage vault. Each row contains a link to the azure table.
SapBusinessObjects.UniversesConnects to the SAP BusinessObjects BI Universe at the specified URL and returns the set of available universes.
Salesforce.DataConnects to the Salesforce Objects API and returns the set of available objects (i.e. Accounts).
Salesforce.ReportsConnects to the Salesforce Reports API and returns the set of available reports.
AnalysisServices.DatabasesReturns the Analysis Services databases on a particular host.
Odbc.QueryConnects to a generic provider with the given connection string and returns the result of evaluating the query.
GoogleAnalytics.AccountsReturns the Google Analytics accounts for the current credential.
FunctionDescription
Uri.CombineReturns a Uri based on the combination of the base and relative parts.
Uri.PartsReturns a record value with the fields set to the parts of a Uri text value.

Reading numbers

FunctionDescription
BinaryFormat.7BitEncodedSignedIntegerA binary format that reads a 64-bit signed integer that was encoded using a 7-bit variable-length encoding.
BinaryFormat.7BitEncodedUnsignedIntegerA binary format that reads a 64-bit unsigned integer that was encoded using a 7-bit variable-length encoding.
BinaryFormat.BinaryReturns a binary format that reads a binary value.
BinaryFormat.ByteA binary format that reads an 8-bit unsigned integer.
BinaryFormat.ByteOrderReturns a binary format with the specified byte order.
BinaryFormat.ChoiceReturns a binary format that chooses the next binary format based on a value that has already been read.
BinaryFormat.DecimalA binary format that reads a .NET 16-byte decimal value.
BinaryFormat.DoubleA binary format that reads an 8-byte IEEE double-precision floating point value.
BinaryFormat.GroupReturns a binary format that reads a group of items. Each item value is preceded by a unique key value. The result is a list of item values.
BinaryFormat.LengthReturns a binary format that limits the amount of data that can be read. Both BinaryFormat.List and BinaryFormat.Binary can be used to read until end of the data. BinaryFormat.Length can be used to limit the number of bytes that are read.
BinaryFormat.ListReturns a binary format that reads a sequence of items and returns a list.
BinaryFormat.NullA binary format that reads zero bytes and returns null.
BinaryFormat.RecordReturns a binary format that reads a record. Each field in the record can have a different binary format.
BinaryFormat.SignedInteger16A binary format that reads a 16-bit signed integer.
BinaryFormat.SignedInteger32A binary format that reads a 32-bit signed integer.
BinaryFormat.SignedInteger64A binary format that reads a 64-bit signed integer.
BinaryFormat.SingleA binary format that reads a 4-byte IEEE single-precision floating point value.
BinaryFormat.TextReturns a binary format that reads a text value. The optional encoding value specifies the encoding of the text.
BinaryFormat.TransformReturns a binary format that will transform the values read by another binary format.
BinaryFormat.UnsignedInteger16A binary format that reads a 16-bit unsigned integer.
BinaryFormat.UnsignedInteger32A binary format that reads a 32-bit unsigned integer.
BinaryFormat.UnsignedInteger64A binary format that reads a 64-bit unsigned integer.
FunctionDescription
Binary.BufferBuffers the binary value in memory. The result of this call is a stable binary value, which means it will have a deterministic length and order of bytes.
Binary.CombineCombines a list of binaries into a single binary.
Binary.FromReturns a binary value from the given value.
Binary.FromListConverts a list of numbers into a binary value
Binary.FromTextDecodes data from a text form into binary.
Binary.LengthReturns the length of binary values.
Binary.ToListConverts a binary value into a list of numbers
Binary.ToTextEncodes binary data into a text form.
FunctionDescription
Lines.FromBinaryConverts a binary value to a list of text values split at lines breaks.
Lines.FromTextConverts a text value to a list of text values split at lines breaks.
Lines.ToBinaryConverts a list of text into a binary value using the specified encoding and lineSeparator.The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.
Lines.ToTextConverts a list of text into a single text. The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.
FunctionDescription
Expression.EvaluateEvaluates a Text expression and returns the evaluated value.
Expression.ConstantReturns a constant text literal from a value.
Expression.IdentifierReturns a text value that can be used as an identifier from a text value.
FunctionDescription
Function.InvokeInvokes the given function using the specified and returns the result.
FunctionDescription
Error.RecordReturns a record containing fields “Reason”, “Message”, and “Detail” set to the provided values. The record can be used to raise or throw an error.
FunctionDescription
Comparer.EqualsReturns a logical value based on the equality check over the two given values.
Comparer.FromCultureReturns a comparer function given the culture and a logical value for case sensitivity for the comparison. The default value for ignoreCase is false. The value for culture are well known text representations of locales used in the .NET framework.
Comparer.OrdinalReturns a comparer function which uses Ordinal rules to compare values.
Culture.CurrentReturns the current culture of the system.
FunctionDescription
Splitter.SplitTextByAnyDelimiterReturns a function that splits text by at any of the delimiters.
Splitter.SplitTextByDelimiterReturns a function that will split text according to a delimiter.
Splitter.SplitTextByEachDelimiterReturns a function that splits text by each delimiter in turn.
Splitter.SplitTextByLengthsReturns a function that splits text according to the specified lengths.
Splitter.SplitTextByPositionsReturns a function that splits text according to the specified positions.
Splitter.SplitTextByRangesReturns a function that splits text according to the specified ranges.
Splitter.SplitTextByWhitespaceReturns a function that splits text according to whitespace.
FunctionDescription
Combiner.CombineTextByDelimiterReturns a function that combines a list of text into a single text using the specified delimiter.
Combiner.CombineTextByEachDelimiterReturns a function that combines a list of text into a single text using each specified delimiter in sequence.
Combiner.CombineTextByLengthsReturns a function that merges a list of text into a single text.
Combiner.CombineTextByPositionsReturns a function that merges a list of text into a single text.
Combiner.CombineTextByRangesReturns a function that merges a list of text into a single text.
FunctionDescription
Replacer.ReplaceTextThis function be provided to List.ReplaceValue or Table.ReplaceValue to do replace of text values in list and table values respectively.
Replacer.ReplaceValueThis function be provided to List.ReplaceValue or Table.ReplaceValue to do replace values in list and table values respectively.
FunctionDescription
Type.AddTableKeyAdd a key to a table type.
Type.ClosedRecordThe given type must be a record type returns a closed version of the given record type (or the same type, if it is already closed)
Type.ForFunctionCreates a function type from the given .
Type.ForListReturns a list type for an item type.
Type.ForNullableReturns a nullable type for a type.
Type.ForRecordReturns a Record type from a fields record.
Type.ForTableConstructs a table type from a row type as a record type.
Type.FunctionParametersReturns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding types.
Type.FunctionRequiredParametersReturns a number indicating the minimum number of parameters required to invoke the a type of function.
Type.FunctionReturnReturns a type returned by a function type.
Type.IsNullableReturns true if a type is a nullable type; otherwise, false.
Type.IsOpenRecordReturns whether a record type is open.
Type.ListItemReturns an item type from a list type.
Type.NonNullableReturns the non nullable type from a type.
Type.OpenRecordReturns an opened version of a record type, or the same type, if it is already open.
Type.RecordFieldsReturns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value that is a record of the form [ Type = type, Opional = logical ].
Type.ReplaceTableKeysReplaces the keys in a table type.
Type.TableKeysReturns keys from a table type.
Type.TableRowReturns a row type from a table type.
Show:
© 2016 Microsoft