Power Query Beyond the User Interface
February 2025
Solving Advanced Data Cleaning Problems Using M
One of the greatest things about Power Query is that it gives you the ability to visualize the output of your actions. Every action you take gets recorded, and you can preview the results in the output window—at least until you can’t. And at that point, you need to be able to figure out your goal, determine the syntax needed to achieve it, and visualize the results without being able to actually see the intermediate values.
One of the most important things that Chandeep does here is illustrate these intermediate steps during his problem-solving journey. Getting to the end results is important, but understanding how you got there is critical to being able to develop your own solutions in the future, and Chandeep’s explanations will help you do exactly that.
Add to Cart: $34.95 »- 232 pages
- Publisher: Holy Macro! Books
- ISBN: 978-1-61547-081-5
- PDF ISBN: 978-1-61547-167-6
You've already transformed your data (along with your life) by learning Power Query. This book will take that transformation a lot further by teaching you the M language that sits behind Power Query's User Interface.
The book will teach you how to think in Power Query. Using a lot of images, concept diagrams and some silly jokes to make you feel at home, as if you and the author were really working through examples in your living room over a coffee.
- Introduction
- Chapter 0: Warming Up
- Chapter 1: Working with Lists
- Chapter 2: Working with Records
- Chapter 3: Working with Tables
- Chapter 4: Navigation
- Chapter 5: Manipulating Between Lists, Records, and Tables
- Chapter 6: If
- Chapter 7: Iteration
- Chapter 8: Custom Functions
- Chapter 9: Errors
- Chapter 10: Nested Tables
- Chapter 11: Patterns and Recipes
- Chapter 12: Miscellaneous Tips and Tricks
- Solutions
- Index
