Archive

Syntax Type.Is(type1 as type, type2 as type) as logical Description Type.Is Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.Is

Syntax Type.ListItem(type as type) as type Description Returns an item type from a list type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.ListItem

Syntax Type.FunctionRequiredParameters(type as type) as number Description Returns a number indicating the minimum number of parameters required to invoke the input type of function. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.FunctionRequiredParameters

Syntax Type.ClosedRecord(type as type) as type Description Returns a closed version of the given record type (or the same type, if it is already closed). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.ClosedRecord

Syntax Type.NonNullable(type as type) as type Description Returns the non nullable type from the type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.NonNullable

Syntax Type.ReplaceTableKeys(tableType as type, keys as list) as type Description Returns a new table type with all keys replaced by the specified list of keys. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.ReplaceTableKeys

Syntax Type.IsNullable(type as type) as logical Description Returns true if a type is a nullable type; otherwise, false. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.IsNullable

Syntax Type.ForRecord(fields as record, open as logical) as type Description Returns a type that represents records with specific type constraints on fields. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.ForRecord

Syntax Type.RecordFields(type as type) as record Description Returns a record describing the fields of a record type. Each field of the returned record type has a corresponding name and a value, in the form of a record [ Type = type, Optional = logical ].… Read More »Type.RecordFields

Syntax Type.TableSchema(tableType as type) as table Description Returns a table describing the columns of tableType. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.TableSchema