Advanced Power Query - Pivot Horizontally Stacked Sets

preview_player
Показать описание
A very clever method for transforming sets of data arranged horizontally.

We use Pivot, Unpivot, Indexes, Integer Division, and Modulo Division.

A useful skillset to use even in other scenarios with Power Query and Power BI.

#powerbi #powerquery #dataanalytics #datamodeling
Рекомендации по теме
Комментарии
Автор

Thank you, Your video solved my problem, where I was stuck for almost the last 17 days. and I had to do it manually. love from Bangladesh.

nazamulislamnazim
Автор

This is really useful and has aided me solving an issue I had with a sharepoint list with over 80 columns.

leemorgan