In this blog, I’ll walk you through the power of lists and nested lists in Power Query using M language. We’ll start from scratch – how to create a list, how to turn that into a nested list, and most importantly, how to apply it in real-world examples. You’ll learn two solid use cases: Replacing errors in multiple columns dynamically and Dividing all ‘USD’ columns by 1000, even when the column names change If you’re working with Power Query and want to get more comfortable with the M language, this video will give you a strong understanding of how nested lists can solve tricky data transformation problems.
