Syntax Table.ContainsAny(table as table, rows as list, optional equationCriteria as any) as logical Description Indicates whether any the specified records in the list of records rows, appear as rows in the table. An optional parameter equationCriteria may be specified to control comparison between the rows… Read More »Table.ContainsAny
Syntax Table.ColumnNames(table as table) as list Description Returns the column names in the table table as a list of text. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ColumnNames
Syntax Table.FirstN(table as table, countOrCondition as any) as table Description Returns the first row(s) of the table table, depending on the value of countOrCondition: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.FirstN
Syntax Table.ReplaceRows(table as table, offset as number, count as number, rows as list) as table Description Replaces a specified number of rows, count, in the input table with the specified rows, beginning after the offset. The rows parameter is a list of records. Reference Data… Read More »Table.ReplaceRows
Syntax null Description An optional parameter in record and table functions indicating that missing fields should result in an error. (This is the default parameter value.) Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / MissingField.Error
Syntax Table.AddKey(table as table, columns as list, isPrimary as logical) as table Description Add a key to table, given columns is the subset of table’s column names that defines the key, and isPrimary specifies whether the key is primary. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Table.AddKey
Syntax Table.Distinct(table as table, optional equationCriteria as any) as table Description Removes duplicate rows from the table table. An optional parameter, equationCriteria, specifies which columns of the table are tested for duplication. If equationCriteria is not specified, all columns are tested. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power… Read More »Table.Distinct
Syntax Table.View(table as nullable table, handlers as record) as table Description Returns a view of table where the functions specified in handlers are used in lieu of the default behavior of an operation when the operation is applied to the view. Handler functions are optional.… Read More »Table.View
Syntax Table.TransformColumns(table as table, transformOperations as list, optional defaultTransformation as nullable function, optional missingField as nullable number) as table Description Returns a table from the input table by applying the transform operation to the column specified in the parameter transformOperations (where format is { column… Read More »Table.TransformColumns
Syntax Table.First(table as table, optional default as any) as any Description Returns the first row of the table or an optional default value, default, if the table is empty. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.First