Chapter 7: Leveraging the M Language

Power Query is based on M language, which stands for Power Query Formula Language. Every time you perform a Power Query step, you are essentially writing M code. You can leverage the UI to transform your data without learning any M language at all but gaining an understanding of it could help you to customize even more Power Query transformations and perform quick corrections that are not possible with the UI only.

In this chapter, we will give an outline of M coding, explaining its differences from Data Analysis Expression (DAX) language (a familiar language to Power BI users), and you will see how to use M code on existing queries and how to create queries from scratch.

You will explore M coding examples ...

Get Power Query Cookbook 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.