We are going to unpivot multiple column combinations in this video. This is part of the Unpivot Variation series which is all about turning your data into a proper tabular format that is suitable for analysis. I will also explore how we can use List.Zip() to unpivot sets of data in Power Query.
**** Video Details ****
0:35 source table
1:13 data pairs and 3 overtime types
2:15 adding custom column - List.Zip
4:11 how to remove value columns
4:39 expand to new rows and generated 3 records
4:52 extract values function
5:10 split by delimiter
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - Power BI Resources - enterprisedna.c...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....