Archive

Table.DuplicateColumn

Syntax Table.DuplicateColumn(table as table, columnName as text, newColumnName as text, optional columnType as nullable type) as table Description Duplicate the column named columnName to the table table. The values and type for the column newColumnName are copied from column columnName. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Table.DuplicateColumn

Table.Max

Syntax Table.Max(table as table, comparisonCriteria as any, optional default as any) as any Description Returns the largest row in the table, given the comparisonCriteria. If the table is empty, the optional default value is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions… Read More »Table.Max

Table.ToRecords

Syntax Table.ToRecords(table as table) as list Description Converts a table, table, to a list of records. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ToRecords

Table.TransformRows

Syntax Table.TransformRows(table as table, transform as function) as list Description Creates a table from table by applying the transform operation to the rows. If the return type of the transform function is specified, then the result will be a table with that row type. In… Read More »Table.TransformRows

Table.ColumnsOfType

Syntax Table.ColumnsOfType(table as table, listOfTypes as list) as list Description Returns a list with the names of the columns from table table that match the types specified in listOfTypes. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ColumnsOfType

Table.MinN

Syntax Table.MinN(table as table, comparisonCriteria as any, countOrCondition as any) as table Description Returns the smallest row(s) in the table, given the comparisonCriteria. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result. Note the sorting algorithm cannot guarantee… Read More »Table.MinN

Table.ToRows

Syntax Table.ToRows(table as table) as list Description Creates a list of nested lists from the table, table. Each list item is an inner list that contains the row values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ToRows

Table.RemoveMatchingRows

Syntax Table.RemoveMatchingRows(table as table, rows as list, optional equationCriteria as any) as table Description Removes all occurrences of the specified rows from the table. An optional parameter equationCriteria may be specified to control the comparison between the rows of the table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power… Read More »Table.RemoveMatchingRows

Table.SelectColumns

Syntax Table.SelectColumns(table as table, columns as any, optional missingField as nullable number) as table Description Returns the table with only the specified columns. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.SelectColumns

Table.ReplaceValue

Syntax Table.ReplaceValue(table as table, oldValue as any, newValue as any, replacer as function, columnsToSearch as list) as table Description Replaces oldValue with newValue in the specified columns of the table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ReplaceValue