I consider myself somewhere between intermediate and advanced in Power Query, but there’s always more to learn. One of the things I enjoy most is discovering new tricks to incorporate into my workflow.

Recently, I watched the latest Power Query Tricks Battle video by Goodly on YouTube, featuring Melissa de Korte and Rick de Groot. It’s packed with creative techniques that can take your Power Query game to the next level.

It’s a shame Melissa’s mic quality wasn’t the best (perhaps she used a built-in laptop mic), but I’m confident her tricks were outstanding.

Watch the video below and tell me if you learned something new, what tricks are you most excited about to try out in your projects, and which of the tricks featured is your favorite?