Summary

This chapter introduced parameters. Parameters, as you’ve seen, are more than mere placeholders in Power Query. They provide you with flexibility and cater to varied scenarios. As you progress in your Power Query journey, you will find yourself reaching out to parameters more and more to make your queries easier to adjust.

We also took a deep dive into the world of custom functions in Power Query M. They allow you to turn your custom queries into reusable logic. You learned how to transform a query into a function without having to write it yourself. We then covered the ins and outs of invoking functions and highlighted the role of the each expression in simplifying the creation of functions.

We also explored how the syntax varies when calling single- versus multi-argument functions. In more intricate situations, where scope becomes a concern, working with the each keyword does not suffice. For these cases, creating your own custom function is required. Beyond...