Power Query isn’t just about simple transformations. Once you start exploring, you’ll find some hidden tricks that make your queries shorter, cleaner, and way more fun to work with. In this blog, I’m sharing 7 of my favourite Power Query tricks, a mix of practical ones you’ll use every day and a few clever ones you probably haven’t seen before. Some of them save you time, some make your queries more dynamic, and a couple are just plain cool (my favourite is trick #7).
