Archive

Syntax GroupKind.Global Description null Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / GroupKind.Global

Syntax null Description JoinAlgorithm.PairwiseHash Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.PairwiseHash

Syntax Table.ViewFunction(function as function) as function Description Creates a view function based on function that can be handled in a view created by Table.View. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ViewFunction

Syntax Table.FillUp(table as table, columns as list) as table Description Returns a table from the table specified where the value of the next cell is propagated to the null-valued cells above in the columns specified. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions… Read More »Table.FillUp

Syntax Table.Combine(tables as list, optional columns as any) as table Description Returns a table that is the result of merging a list of tables, tables. The resulting table will have a row type structure defined by columns or by a union of the input types… Read More »Table.Combine

Syntax Table.PrefixColumns(table as table, prefix as text) as table Description Returns a table where all the column names from the table provided are prefixed with the given text, prefix, plus a period in the form prefix .ColumnName. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Table.PrefixColumns

Syntax Table.FirstValue(table as table, optional default as any) as any Description Returns the first column of the first row of the table table or a specified default value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.FirstValue

Syntax Table.ReplaceKeys(table as table, keys as list) as table Description Table.ReplaceKeys Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ReplaceKeys

Syntax null Description JoinAlgorithm.LeftIndex Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinAlgorithm.LeftIndex

Syntax Table.Column(table as table, column as text) as list Description Returns the column of data specified by column from the table table as a list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.Column