View My Drafts
In this tutorial, we'll revisit a topic I covered earlier about how to unpivot multiple columns in Power Query using List.Zip. An Enterprise DNA member asked on the forum on how to make that method dynamic. You may watch the full video of this tutorial at the bottom of this blog.
I've labeled this advanced because we'll be writing a number of M functions and some of those might even be new to you.
With that said, let's go over to Power Query.Ref: Unpivot Multiple Columns Dynamically In Power BI