When you build queries using the Power Query designer, the designer creates the query using the M query language. Although you can create robust queries using just the visual interface, there is a lot of useful processing that you can only complete by writing M code. This chapter goes beyond the basics and explores some of the advanced functionality in Power Query, including the M query language, parameters, and functions.
After completing this chapter, you will be able to
Write queries with the M query language
Create and use parameters
Create and use functions
Writing Queries with M
When ...
