Power Query Recipes

Abstract

You have now learned all about the functionality of Power Query, but when you are learning about a new tool it isn’t enough to know what each button does when you press it, or what each function returns when you call it. You also need to know how to solve problems with Power Query. In this final chapter you will see a number of reasonably complex examples that demonstrate how to solve some common problems with Power Query. The purpose of this is twofold: to provide a number of ready-made queries that you can adapt for your own purposes, and to show you how to “think” in Power Query and M. By following a recipe you learn to cook the exact dish that the author set out to describe when he or she wrote the recipe down, and at the same time you are learning cooking skills that will allow you to make up your own recipes later on. The same is true with Power Query.