© Dan Clark 2020
Dan ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_13

13. Advanced Topics in Power Query

Dan Clark
(1)
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
  • Write queries with the M query language
  • Create and use parameters
  • Create and use functions

Writing Queries with M

Get Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.