Karachi Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Unpivot Multiple Columns Dynamically In Power BI

  • 1.  Unpivot Multiple Columns Dynamically In Power BI

    Top Contributor
    Posted Mar 25, 2021 02:17 AM

    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

    Enterprise DNA remove preview
    Unpivot Multiple Columns Dynamically In Power BI
    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 on how to make that method dynamic. You may watch the full video of this tutorial at the bottom of this blog.
    View this on Enterprise DNA >





    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------