- Write queries with the M query language
- Create and use parameters
- Create and use functions
© Dan Clark 2020Dan ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_13
13. Advanced Topics in Power Query
Camp Hill, PA, USA
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