Courses / Power Query (Get & Transform)
5. M values: tables
Table as a core Power Query data structure and how it differs from lists and records.
Power Query M
M values: tables
A Table in M is a two-dimensional, typed collection of rows and columns (like an Excel sheet) represented as an immutable value.
"I want to transform a spreadsheet-like set of rows and columns while keeping transformations composable and safe."
A Table is an M value holding rows (records) with the same set of columns; table-transforming functions return new table values rather than modifying in place.
"I want to transform a spreadsheet-like set of rows and columns while keeping transformations composable and safe."
A Table is an M value holding rows (records) with the same set of columns; table-transforming functions return new table values rather than modifying in place.