Syntax Table.RowCount(table as table) as number Description Returns the number of rows in the table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.RowCount
Syntax Table.Profile(table as table, optional additionalAggregates as nullable list) as table Description Returns a profile for the columns in table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Profile
Syntax null Description If the splitter function returns more columns than the table expects, they should be ignored. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / ExtraValues.Ignore
Syntax Table.ToList(table as table, optional combiner as nullable function) as list Description Converts a table into a list by applying the specified combining function to each row of values in the table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ToList
Syntax Table.ExpandListColumn(table as table, column as text) as table Description Given a table, where a column is a list of values, splits the list into a row for each value. Values in the other columns are duplicated in each new row created. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference… Read More »Table.ExpandListColumn
Syntax Table.RemoveLastN(table as table, optional countOrCondition as any) as table Description Returns a table that does not contain the last countOrCondition rows of the table table. The number of rows removed depends on the optional parameter countOrCondition. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Table.RemoveLastN
Syntax Table.RemoveRowsWithErrors(table as table, optional columns as nullable list) as table Description Returns a table with the rows removed from the input table that contain an error in at least one of the cells. If a columns list is specified, then only the cells in… Read More »Table.RemoveRowsWithErrors
Syntax RowExpression.From(function as function) as record Description Returns the AST for the body of function, normalized into 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.From
Syntax Table.FromPartitions(partitionColumn as text, partitions as list, optional partitionColumnType as nullable type) as table Description Returns a table that is the result of combining a set of partitioned tables, partitions. partitionColumn is the name of the column to add. The type of the column defaults… Read More »Table.FromPartitions
Syntax Table.SelectRowsWithErrors(table as table, optional columns as nullable list) as table Description Returns a table with only those rows of the input table that contain an error in at least one of the cells. If a columns list is specified, then only the cells in… Read More »Table.SelectRowsWithErrors