Turn Calendar Type Layout Into Tabular Format In Power BI - Query Editor Tutorial

This video is part of our unpivot variation series. Here, I will be discussing how to transform vertical and horizontal repeated data into a tabular format for analysis in Power BI using Power Query.

Hope you enjoy this one.

Melissa

*****Video Details*****
1:24 remove unnecessary rows and columns
4:17 break the tables
6:13 identify the list for the new tables
9:15 group data back together
9:55 Group By method
13:30 combine tables back together
15:02 unpivot columns

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI -
FREE COURSE - Ultimate Beginners Guide To DAX -
FREE - Power BI Resources -
FREE - 60 Page DAX Reference Guide Download -
Enterprise DNA Membership -
Enterprise DNA Online -
Enterprise DNA Events -

enterprise dna,sam mckay,unpivot tables,calendar layout,tabular format,power bi tutorial,power bi tutorial for beginners,power query,query editor,