Power Query M Primer

Sooner or later, you may find yourself working directly with Power Query’s M formula language. Tools like Microsoft Excel’s Get & Transform Data and Microsoft Power BI provide point-and-click interfaces allowing you to build data transformation sequences which behind-the-scenes are implemented in Power Query’s M language. However, these query editors can’t do everything you might need. Using Power Query to its full potential involves, at times, directly reading and writing M code.

Search the Internet and you’ll find many examples showing how to use Power Query and the M language to solve one problem or another but little is out there describing the syntax and paradigm of the M language in detail. A limited knowledge of these details may be insignificant when simply copying and pasting samples and editing variable and column names, but move beyond this to weaving and writing your own solutions directly in M and a solid understanding of the language’s syntax, rules and capabilities becomes most helpful.

Grab a seat and buckle your safety harness! We’re going to barrel down the tracks, take some dives, loops and perhaps even a wiz around a few tight curves as we take a deep, systematic dive into M, the language at the heart of Power Query.

Prefer to learn about M in a live, web-class format instead? Then check out the Meet M: The Language That Powers Power Query class!