CHAPTER 8

image

Power Query Recipes

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

Get Power Query for Power BI and Excel now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.