Courses / Power Query (Get & Transform)
22. M values: lists
What a list is in M and basic list creation and indexing syntax.
Power Query M
M values: lists
A list in M is an ordered collection of values written between curly braces, accessed by zero-based numeric positions.
"I want to keep a small sequence of values (like column headers or lookup keys) and grab items by position."
A list is an ordered, indexable sequence in M written {a, b, c}; you can create it literally or with functions and access items using curly-brace indexing (zero-based).
"I want to keep a small sequence of values (like column headers or lookup keys) and grab items by position."
A list is an ordered, indexable sequence in M written {a, b, c}; you can create it literally or with functions and access items using curly-brace indexing (zero-based).