Syntax Table.Group(table as table, key as any, aggregatedColumns as list, optional groupKind as nullable number, optional comparer as nullable function) as table Description Groups the rows of table by the values in the specified column,key, for each row. For each group, a record is constructed… Read More »Table.Group
Syntax Table.TransformColumnTypes(table as table, typeTransformations as list, optional culture as nullable text) as table Description Returns a table from the input table by applying the transform operation to the columns specified in the parameter typeTransformations (where format is { column name, type name}), using the… Read More »Table.TransformColumnTypes
Syntax Table.NestedJoin(table1 as table, key1 as any, table2 as any, key2 as any, newColumnName as text, optional joinKind as nullable number, optional keyEqualityComparers as nullable list) as table Description Joins the rows of table1 with the rows of table2 based on the equality of the… Read More »Table.NestedJoin
Syntax Tables.GetRelationships(tables as table, optional dataColumn as nullable text) as table Description Gets the relationships among a set of tables. The set tables is assumed to have a structure similar to that of a navigation table. The column defined by dataColumn contains the actual data… Read More »Tables.GetRelationships
Syntax Table.FuzzyGroup(table as table, key as any, aggregatedColumns as list, optional options as nullable record) as table Description Groups the rows of table by fuzzily matching values in the specified column, key, for each row. For each group, a record is constructed containing the key… Read More »Table.FuzzyGroup
Syntax Table.DemoteHeaders(table as table) as table Description Demotes the column headers (i.e. column names) to the first row of values. The default column names are “Column1”, “Column2” and so on. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.DemoteHeaders
Syntax Table.ReplaceErrorValues(table as table, errorReplacement as list) as table Description Replaces the error values in the specified columns of the table with the new values in the errorReplacement list. The format of the list is {{column1, value1}, …}. There may only be one replacement value… Read More »Table.ReplaceErrorValues
Syntax Table.IsDistinct(table as table, optional comparisonCriteria as any) as logical Description Indicates whether the table contains only distinct rows (no duplicates). Returns true if the rows are distinct, false otherwise. An optional parameter, comparisonCriteria, specifies which columns of the table are tested for duplication. If… Read More »Table.IsDistinct
Syntax Table.RemoveColumns(table as table, columns as any, optional missingField as nullable number) as table Description Removes the specified columns from the table provided. If the column doesn’t exist, an exception is thrown unless the optional parameter missingField specifies an alternative (eg. MissingField.UseNull or MissingField.Ignore). Reference… Read More »Table.RemoveColumns
Syntax null Description A possible value for the optional JoinKind parameter in Table.Join. A right anti join returns that all rows from the second table which do not have a match in the first 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.RightAnti