Table.FromRecords
Organizing and formatting individual records into a structured table format.
Table.FromRecords(records as list, optional columns as any, optional missingField as nullable number) as tableGenerate a table by organizing data records into columns with headings matching the field names in the records.
Instructions:
1. Use the Power Query M function MTable.FromRecords to create a table using the provided records. Each record contains fields like CustomerID, Name, and Phone.
2. Follow the format shown in the example to structure the table with the appropriate field values.
Sample Input:
MTable.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"]
})
Expected Output:
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"]
})