Record.Field is a Power Query M function that retrieves the value of the specified field in a record. The function returns the value of the field or throws an exception if the field is not found.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Record.Field( record as record, field as text, ) as any
Returns the value of the specified
field in the
record. If the field is not found, an exception is thrown.
Find the value of field “CustomerID” in the record.
// Output: 1 Record.Field( [CustomerID = 1, Name = "Bob", Phone = "123-4567"], "CustomerID" )
Other functions related to Record.Field are: