Syntax Table.HasColumns(table as table, columns as any) as logical Description indicates whether the table contains the specified column(s), columns. Returns true if the table contains the column(s), false otherwise. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.HasColumns
Syntax null Description An AST node representing the item in an item expression. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / ItemExpression.Item
Syntax Table.Partition(table as table, column as text, groups as number, hash as function) as list Description Partitions the table into a list of groups number of tables, based on the value of the column and a hash function. The hash function is applied to the… Read More »Table.Partition
Syntax Table.PositionOf(table as table, row as record, optional occurrence as any, optional equationCriteria as any) as any Description Returns the row position of the first occurrence of the row in the table specified. Returns -1 if no occurrence is found. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Table.PositionOf
Syntax Table.Join(table1 as table, key1 as any, table2 as table, key2 as any, optional joinKind as nullable number, optional joinAlgorithm as nullable number, optional keyEqualityComparers as nullable list) as table Description Joins the rows of table1 with the rows of table2 based on the equality… Read More »Table.Join
Syntax Table.Contains(table as table, row as record, optional equationCriteria as any) as logical Description Indicates whether the specified record, row, appears as a row in the table. An optional parameter equationCriteria may be specified to control comparison between the rows of the table. Reference Data… Read More »Table.Contains
Syntax Table.SelectRows(table as table, condition as function) as table Description Returns a table of rows from the table, that matches the selection condition. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.SelectRows
Syntax GroupKind.Local Description GroupKind.Local Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / GroupKind.Local
Syntax Table.Schema(table as table) as table Description Returns a table describing the columns of table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Schema
Syntax null Description A possible value for the optional JoinKind parameter in Table.Join. A right outer join ensures that all rows of the second table appear in the result. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinKind.RightOuter