Record.Combine is a Power Query M function that combines the records in the given records. The function returns a single record that contains all the fields from the input records, or an error if any input value is not a record.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Record.Combine( records as list ) as recordDescription
Combines the records in the given records. If the records contains non-record values, an error is returned.
Examples
Create a combined record from the records.
// Output: [CustomerID = 1, Name = "Bob", Phone = "123-4567"]
Record.Combine( {
[CustomerID = 1, Name = "Bob"],
[Phone = "123-4567"]
} )Related functions
Other functions related to Record.Combine are:
