In this blog, I walk through some of my favourite Power Query M functions and, more importantly, how they show up in real-life data cleaning work. You’ll see when to use Folder.Contents instead of Folder.Files, how List.Select and List.Transform can help you target just the columns you need, how to drive Table.TransformColumns dynamically, how records let you build multiple calculated columns in one step, and how Table.Skip can remove messy top rows even when the junk isn’t a fixed count. Along the way, I show the full thought process so you can reuse these patterns in your own projects instead of just copying code.
