Unpivot Multiple Column Pairs In Power Query
Автор: Enterprise DNA
Загружено: 2020-09-21
Просмотров: 23828
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 - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
