2

Working with Power Query/M

In Chapter 1, Introducing M, we introduced the fundamental aspects of the M language. In the section Where is M used?, we briefly introduced the concept of Power Query experiences, including Power Query Desktop and Power Query Online.

This chapter provides greater detail regarding working with M within the Power Query Desktop experience using Power BI Desktop. The knowledge covered here will allow you to start writing M code via an easy-to-use graphical user interface (GUI) provided by the Power Query Editor and is directly translatable to other desktop experiences, such as that found in Excel as well as the Power Query Online experience within websites such as powerbi.com. In effect, the Power Query Desktop experience ...

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.