Syntax Table.FilterWithDataTable(**table** as table, **dataTableIdentifier** as text) as any Description Table.FilterWithDataTable Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.FilterWithDataTable
Syntax Table.Buffer(table as table) as table Description Buffers a table in memory, isolating it from external changes during evaluation. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Buffer
Syntax Table.SplitColumn(table as table, sourceColumn as text, splitter as function, optional columnNamesOrNumber as any, optional default as any, optional extraColumns as any) as table Description Splits the specified columns into a set of additional columns using the specified splitter function. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Table.SplitColumn
Syntax null Description Specifies the left 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.Left
Syntax Table.ColumnCount(table as table) as number Description Returns the number of columns in the table table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ColumnCount
Syntax null Description If the splitter function returns more columns than the table expects, an error should be raised. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / ExtraValues.Error
Syntax Table.RenameColumns(table as table, renames as list, optional missingField as nullable number) as table Description Performs the given renames to the columns in table table. A replacement operation renames consists of a list of two values, the old column name and new column name, provided… Read More »Table.RenameColumns
Syntax Table.AddJoinColumn(table1 as table, key1 as any, table2 as function, key2 as any, newColumnName as text) as table Description Joins the rows of table1 with the rows of table2 based on the equality of the values of the key columns selected by key1 (for table1)… Read More »Table.AddJoinColumn
Syntax null Description JoinAlgorithm.SortMerge Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.SortMerge
Syntax Table.Split(table as table, pageSize as number) as list Description Splits table into a list of tables where the first element of the list is a table containing the first pageSize rows from the source table, the next element of the list is a table… Read More »Table.Split