From the course: Learning Power BI Desktop [Update]
Join today to access over 24,700 courses taught by industry experts.
Transform columns
From the course: Learning Power BI Desktop [Update]
Transform columns
- [Instructor] Covering all the commands in the Power query editors, much more than we can do in this course, but I want to show you some specific choices that might be useful for you as you're working with data for your organization. And I also want to encourage you to spend some time looking through the contents of the query editor. If we look at the table section of the transform tab, we have commands here, like first rows headers, but if we wanted to pivot this entire table 90 degrees, turn rows into columns and columns into rows, that's called transposition. And there's a command that does that here. It's also available to us in Microsoft Excel. You can reverse the rows, you can count the number of rows that you have. In the any column group we can change the data type. We can also go back and detect the data type. Data type detection happens as soon as we're bringing data in. It's part of the load and transform operation. But if, for example, I had a lot of null values, it would…
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.