4
Understanding Values and Expressions
Now that we have covered an overview of M, reviewed the elements of the Power Query user interface (UI), and discussed how to access and combine our data, we are ready to dive into the specific components of the M language. Values comprise the first component, following naturally from our previous chapter since every time you ingest files into Power Query, each of the individual elements of data is a value.
If you think of Power Query and M as the lab where you go to clean and shape your data so that it’s well-prepped for data modeling and reporting, then values are the atoms of M code – the smallest single units. These values are combined to form expressions, making them the molecules of our lab. One or ...
Get The Definitive Guide to Power Query (M) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
