Type functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

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.FacetsReturns the facets of a type.
Type.ForFunctionCreates a function type from the given .
Type.ForRecordReturns a Record type from a fields record.
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.IsType.Is
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.ReplaceFacetsReplaces the facets of a type.
Type.ReplaceTableKeysReplaces the keys in a table type.
Type.TableColumnReturns the type of a column in a table.
Type.TableKeysReturns keys from a table type.
Type.TableRowReturns a row type from a table type.
Type.TableSchemaReturns a table containing a description of the columns (i.e. the schema) of the specified table type.
Type.UnionReturns the union of a list of types.
Show: