Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

© Dan Clark 2020

D. 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

When ...