Syntax Table.FromRecords(records as list, optional columns as any, optional missingField as nullable number) as table Description Converts records, a list of records, into a table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.FromRecords
Syntax Table.MaxN(table as table, comparisonCriteria as any, countOrCondition as any) as table Description Returns the largest 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.MaxN
Syntax null Description A possible value for the optional JoinKind parameter in Table.Join. A full outer join ensures that all rows of both tables appear in the result. Rows that did not have a match in the other table are joined with a default row… Read More »JoinKind.FullOuter
Syntax Table.RemoveFirstN(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 removed 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.RemoveFirstN
Syntax Table.Repeat(table as table, count as number) as table Description Returns a table with the rows from the input table repeated the specified count times. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Repeat
Syntax null Description An optional parameter in record and table functions indicating that missing fields should be ignored. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / MissingField.Ignore
Syntax ItemExpression.From(function as function) as record Description Returns the AST for the body of function, normalized into an item expression: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / ItemExpression.From
Syntax Table.Keys(table as table) as list Description Table.Keys Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Keys
Syntax Table.FromColumns(lists as list, optional columns as any) as table Description Creates a table of type columns from a list lists containing nested lists with the column names and values. If some columns have more values then others, the missing values will be filled with… Read More »Table.FromColumns
Syntax null Description A possible value for the optional JoinKind parameter in Table.Join. The table resulting from an inner join contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns. Reference Data… Read More »JoinKind.Inner