Syntax Table.ReplaceMatchingRows(table as table, replacements as list, optional equationCriteria as any) as table Description Replaces all the specified rows in the table with the provided ones. The rows to replace and the replacements are specified in replacements, using {old, new} formatting. An optional equationCriteria parameter… Read More »Table.ReplaceMatchingRows
Syntax Table.ReplaceRelationshipIdentity(value as any, identity as text) as any Description Table.ReplaceRelationshipIdentity Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.ReplaceRelationshipIdentity
Syntax Table.Min(table as table, comparisonCriteria as any, optional default as any) as any Description Returns the smallest row in the table, given the comparisonCriteria. If the table is empty, the optional default value is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions… Read More »Table.Min
Syntax Table.ExpandTableColumn(table as table, column as text, columnNames as list, optional newColumnNames as nullable list) as table Description Expands tables in table[column] into multiple rows and columns. columnNames is used to select the columns to expand from the inner table. Specify newColumnNames to avoid conflicts… Read More »Table.ExpandTableColumn
Syntax null Description A possible value for the optional JoinKind parameter in Table.Join. A left outer join ensures that all rows of the first table appear in the result. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / JoinKind.LeftOuter
Syntax Table.AggregateTableColumn(table as table, column as text, aggregations as list) as table Description Aggregates tables in table[column] into multiple columns containing aggregate values for the tables. aggregations is used to specify the columns containing the tables to aggregate, the aggregation functions to apply to the… Read More »Table.AggregateTableColumn
Syntax Table.RemoveRows(table as table, offset as number, optional count as nullable number) as table Description Removes count of rows from the beginning of the table, starting at the offset specified. A default count of 1 is used if the count parameter isn’t provided. Reference Data… Read More »Table.RemoveRows
Syntax Table.SingleRow(table as table) as record Description Returns the single row in the one row table. If the table has more than one row, an exception is thrown. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Table Functions / Table.SingleRow
Syntax Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Description Translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Table.Unpivot
Syntax Splitter.SplitTextByLengths(lengths as list, optional startAtEnd as nullable logical) as function Description Returns a function that splits text into a list of text by each specified length. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitTextByLengths