Record.Combine

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Combines the records in a list.

Record.Combine(list as list) as record  

ArgumentDescription
listThe list of records to combine.

If the list contains non-record values, an error is returned.

Record.Combine({ [CustomerID =1], [Name ="Bob"] , [Phone =  "123-4567"] })  

equals [CustomerID=1, Name="Bob", Phone="123-4567"]  

CustomerID1
NameBob
Phone123-4567
Show: