© Dan Clark 2017

Dan Clark, Beginning Power BI, 10.1007/978-1-4842-2577-6_13

13. Advanced Topics in Power Query

Dan Clark

(1)Camp Hill, Pennsylvania, 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 you build ...

Get Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.