Advanced PowerQuery: The Mashup Language

About this course

Empower your ability to transform data..The Query Editor that supports Get & Transform is powerful and allows even the newest Excel users to create powerful data manipulation queries with only their mouse and, occasionally, a few keyboard inputs. Behind each query is the powerful Mashup language, "M" for short. Picking up even a few tips and tricks with the language itself can allow you to create even more useful and powerful queries far faster than with strictly the editor alone.In this course, you'll dive behind the Query Editor to learn about the syntax and structure of M Code so that you can build queries with the query editor and make manual adjustments to create results not achievable strictly through the graphical interface.Save time with reusable query code..Found yourself loving how quickly you can do so many things in the Query Editor but feel like you've been doing the same thing over and over? You probably have been and there's a solution for that!With a few extra lines of code, you can turn many of your queries that you've duplicated and re-used over and over again into directly re-usable functions that will save you time, hassle, and dramatically improve your ability to maintain, update, and edit your queries.In this course, you will learn about how to build reusable functions from existing queries or from scratch to give you the ability to build custom reusable user functions within your Query Editor. Incorporate complex logic into your transformations..Have you ever found yourself needing the results of an iterative calculation based upon a combination of fields or wanting to compute a compound calculation based upon other rows within the same data set?These types of problems require complex logic that is generally the realm of true object oriented languages and other solutions rather than database computations like those generated from SQL.The