From the course: Learning Power BI Desktop [Update]
Join today to access over 24,700 courses taught by industry experts.
Unpivot columns
From the course: Learning Power BI Desktop [Update]
Unpivot columns
- [Instructor] We were working with this dataset in the last movie, it's historical data from the census from the years 1790 to 1860. And we have now used the transformational tools to exclude any territory that wasn't a state by 1860 and any territory that was never a state like Washington, DC. And also we had a grand total for the United States as a whole. So now we have 42 rows that you could think of as the census from 1790 to 1860 for states that actually existed by 1860 in the United States. If you look at this dataset, it is actually a PivotTable. Originally there was transactional data. Let's look at Connecticut, the first state for which we have every single year, we have a figure. There was a census taken in 1790 in Connecticut, and they counted about a quarter of a million people. Same 10 years later, and the figures keep going up. So this census is actually happening. And each of these was a transaction. In 1790, there was a record that said Connecticut 237,946, Delaware…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.