Open Daily: 10am - 10pm | Alley door pickup 10am - 7pm 3038 Hennepin Ave Minneapolis, MN
612-822-4611

  • Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
Power Query M Language: Build Custom Functions for Advanced Data Transformation

Power Query M Language: Build Custom Functions for Advanced Data Transformation

Kendrick, Troy

Paperback

DatabasesGeneral Computers

ISBN13: 9798180922724
Publisher: Independently Published
Published: Jun 10 2026
Pages: 324
Weight: 1.66
Height: 0.68 Width: 8.50 Depth: 11.00
Language: English
Ever opened Power Query, clicked a few buttons, and thought, Yeah... I totally know what I'm doing-only to get lost five steps later?

Welcome to the club.

Hi, I'm Troy Kendrick, and this book is your friendly, no-nonsense guide to finally understanding the mysterious (and surprisingly powerful) world of the Power Query M Language-without falling asleep halfway through.

Power Query M Language: Build Custom Functions for Advanced Data Transformation is not your typical dry, overly technical manual. This is the book I wish I had when I first stared at M code like it was written by aliens with a spreadsheet obsession.

Inside, you'll go from copy-pasting random formulas from the internet to confidently writing your own custom functions like a data wizard.

Here's what you'll learn (without the headache):

  • How Power Query actually works (yes, finally)
  • The logic behind M Language syntax-made simple
  • How to work with lists, records, and tables without confusion
  • Writing custom functions that save you hours of repetitive work
  • Advanced tricks like recursion and function chaining (sounds scary, isn't)
  • How to debug errors without wanting to flip your desk
  • Performance tips to make your queries faster and smarter
  • Real-world data transformation techniques you can actually use

Also in

General Computers

View All