Syntax Table.PromoteHeaders(table as table, optional options as nullable record) as table Description Promotes the first row of values as the new column headers (i.e. column names). By default, only text or number values are promoted to headers. Valid options: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Table.PromoteHeaders
Syntax Table.IsEmpty(table as table) as logical Description Indicates whether the table contains any rows. Returns true if there are no rows (i.e. the table is empty), false otherwise. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.IsEmpty
Syntax Table.Last(table as table, optional default as any) as any Description Returns the last 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.Last
Syntax RowExpression.Column(columnName as text) as record Description Returns an AST that represents access to column columnName of the row within a row expression. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / RowExpression.Column
Syntax null Description An optional parameter in record and table functions indicating that missing fields should be included as null values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / MissingField.UseNull
Syntax Table.FuzzyJoin(table1 as table, key1 as any, table2 as table, key2 as any, 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 the values of… Read More »Table.FuzzyJoin
Syntax Table.CombineColumns(table as table, sourceColumns as list, combiner as function, column as text) as table Description Combines the specified columns into a new column using the specified combiner function. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.CombineColumns
Syntax Table.PositionOfAny(table as table, rows as list, optional occurrence as nullable number, optional equationCriteria as any) as any Description Returns the row(s) position(s) from the table of the first occurrence of the list of rows. Returns -1 if no occurrence is found. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference… Read More »Table.PositionOfAny
Syntax Table.FindText(table as table, text as text) as table Description Returns the rows in the table table that contain the text text. If the text is not found, an empty table is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.FindText
Syntax Table.InsertRows(table as table, offset as number, rows as list) as table Description Returns a table with the list of rows, rows, inserted into the table at the given position, offset. Each column in the row to insert much match the column types of the… Read More »Table.InsertRows