Syntax Table.FromValue(value as any, optional options as nullable record) as table Description Creates a table with a column containing the provided value or list of values, value. An optional record parameter, options, may be specified to control the following options: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Table.FromValue
Syntax Table.FromRows(rows as list, optional columns as any) as table Description Creates a table from the list rows where each element of the list is an inner list that contains the column values for a single row. An optional list of column names, a table… Read More »Table.FromRows
Syntax null Description A possible value for the optional JoinKind parameter in Table.Join. A left anti join returns that all rows from the first table which do not have a match in the second table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions… Read More »JoinKind.LeftAnti
Syntax null Description JoinAlgorithm.LeftHash Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.LeftHash
Syntax null Description JoinAlgorithm.Dynamic Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.Dynamic
Syntax Table.MatchesAnyRows(table as table, condition as function) as logical Description Indicates whether any the rows in the table match the given condition. Returns true if any 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.MatchesAnyRows
Syntax null Description JoinAlgorithm.RightHash Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.RightHash
Syntax Table.Range(table as table, offset as number, optional count as nullable number) as table Description Returns the rows from the table starting at the specified offset. An optional parameter, count, specifies how many rows to return. By default, all the rows after the offset are… Read More »Table.Range
Syntax null Description Specifies the right table of a join. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinSide.Right
Syntax Table.ReverseRows(table as table) as table Description Returns a table with the rows from the input table in reverse order. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ReverseRows