Record.ToTable
A record turned into a table of two columns, Name and Value, a row per field.
Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Record.ToTable(record as record) as table| Parameter | Type | Description |
|---|---|---|
record | record | The record to turn into rows. |
Returns
table. Two columns, Name and Value: a row for each field.
Examples
One row per field
Record.ToTable([Name = "Ann", City = "Oslo", Since = #date(2021, 3, 1)])| Name | Value |
|---|---|
| Name | Ann |
| City | Oslo |
| Since | 2021-03-01 |