Courses / Power Query (Get & Transform)
23. M values: records
What a record is in M and how to access fields by name.
Power Query M
M values: records
A record is a single row-like value that groups named fields (like columns) and their values.
"I want to bundle related values together and pick out one by name, like grabbing a cell from a row."
A record in M is a set of name=value pairs enclosed in [ ... ], and you access a field by name using either dot notation (when the field name is a simple identifier) or bracket notation with the field name/expression.
"I want to bundle related values together and pick out one by name, like grabbing a cell from a row."
A record in M is a set of name=value pairs enclosed in [ ... ], and you access a field by name using either dot notation (when the field name is a simple identifier) or bracket notation with the field name/expression.