Syntax null Description An AST node representing the row in 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.Row
Syntax Table.Pivot(table as table, pivotValues as list, attributeColumn as text, valueColumn as text, optional aggregationFunction as nullable function) as table Description Given a pair of columns representing attribute-value pairs, rotates the data in the attribute column into a column headings. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Table.Pivot
Syntax Table.Transpose(table as table, optional columns as any) as table Description Makes columns into rows and rows into columns. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Transpose
Syntax null Description If the splitter function returns more columns than the table expects, they should be collected into a list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / ExtraValues.List
Syntax null Description JoinAlgorithm.RightIndex Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.RightIndex
Syntax Table.MatchesAllRows(table as table, condition as function) as logical Description Indicates whether all the rows in the table match the given condition. Returns true if all of the rows match, false otherwise. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.MatchesAllRows
Syntax Table.AlternateRows(table as table, offset as number, skip as number, take as number) as table Description Keeps the initial offset then alternates taking and skipping the following rows. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.AlternateRows
Syntax Table.LastN(table as table, countOrCondition as any) as table Description Returns the last row(s) from 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.LastN
Syntax Table.ExpandRecordColumn(table as table, column as text, fieldNames as list, optional newColumnNames as nullable list) as table Description Given the column of records in the input table, creates a table with a column for each field in the record. Optionally, newColumnNames may be specified to… Read More »Table.ExpandRecordColumn
Syntax Table.Sort(table as table, comparisonCriteria as any) as table Description Sorts the table using the list of one or more column names and optional comparisonCriteria in the form { { col1, comparisonCriteria }, {col2} }. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions… Read More »Table.Sort