Syntax Table.FromList(list as list, optional splitter as nullable function, optional columns as any, optional default as any, optional extraValues as nullable number) as table Description Converts a list, list into a table by applying the optional splitting function, splitter, to each item in the list.… Read More »Table.FromList
Syntax Table.AddColumn(table as table, newColumnName as text, columnGenerator as function, optional columnType as nullable type) as table Description Adds a column named newColumnName to the table table. The values for the column are computed using the specified selection function columnGenerator with each row taken as… Read More »Table.AddColumn
Syntax Table.ContainsAll(table as table, rows as list, optional equationCriteria as any) as logical Description Indicates whether all 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.ContainsAll
Syntax Table.TransformColumnNames(table as table, nameGenerator as function, optional options as nullable record) as table Description Transforms column names by using the given nameGenerator function. Valid options: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.TransformColumnNames
Syntax Table.ReorderColumns(table as table, columnOrder as list, optional missingField as nullable number) as table Description Returns a table from the input table, with the columns in the order specified by columnOrder. Columns that are not specified in the list will not be reordered. If the… Read More »Table.ReorderColumns
Syntax Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number) as table Description Appends a column named newColumnName to the table with explicit position values. An optional value, initialValue, the initial index value. An optional value, increment, specifies… Read More »Table.AddIndexColumn
Syntax Table.ToColumns(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 column values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ToColumns
Syntax Table.FillDown(table as table, columns as list) as table Description Returns a table from the table specified where the value of a previous cell is propagated to the null-valued cells below in the columns specified. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions… Read More »Table.FillDown
Syntax Table.Skip(table as table, optional countOrCondition as any) as table Description Returns a table that does not contain the first specified number of rows, countOrCondition, of the table table. The number of rows skipped depends on the optional parameter countOrCondition. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Table.Skip
Syntax Table.FuzzyNestedJoin(table1 as table, key1 as any, table2 as table, key2 as any, newColumnName as text, optional joinKind as nullable number, optional joinOptions as nullable record) as table Description Joins the rows of table1 with the rows of table2 based on a fuzzy matching of… Read More »Table.FuzzyNestedJoin