Resources
Constructing lists in Power Query/M
The Power Query M language involves the construction of lists, which is made easier by understanding a few critical facts about them. A list is essentially an ordered sequence of values, separated by commas. Notably, list items aren't evaluated until accessed, and a list can theoretically contain an infinite number of items.
The List.Count for such lists is undefined and attempting to define it may either cause an error or result in non-termination. Importantly, the native type of list values in the Power Query M language is the intrinsic type list. This specifies that the item type is of type 'any', hence list items can be of any type, be it primitive or structured. To initialize a list, one would use a set of curly brackets { }. Having covered these basics, it's time to delve into the practical aspect of constructing a list, which is conveniently provided in PDF for future reference.
What our Students Say
Your Author

EDNA Team
Data & AI
Frequently Asked
Questions
What’s the difference between a free account and a paid plan?
Do I need to know anything about data science or data analytics to get started with Enterprise DNA?
How will I be charged?
Can I get an invoice for my company?
Are refunds available?
Will AI take over the world and make data skills worthless?
Get full access to unparalleled
training & skill-building resources

FOR INDIVIDUALS
Enterprise DNA
For Individuals
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.
Learn More chevron_rightFOR BUSINESS
Enterprise DNA
For Business
Training, tools, and guidance to unify and upskill the data analysts in your workplace.
Learn More chevron_right