From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Set up calculations with PivotTables for the latest month
From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)
Set up calculations with PivotTables for the latest month
- [Instructor] Now that we've imported the data, to the data model, and we've also created the relationships that we need, it's time to do you do the calculations for our dashboard. We're going to use the help of PivotTables to get these done really fast. Now, the first thing that we need is to figure out which month is the latest month so that we can grab all the information we need for the dashboard. Let's go and set up our first PivotTable. So, let's go back to the calculation tab, go to insert PivotTable, use this workbook's data model and okay. We get our PivotTable fields here, and we just drag this and bring it closer to our PivotTable. These are our different tables and inside we can see the column headers. Now, I prefer to organize this slightly different. Let's go with field selection and selection area side by side. This gives us a better view of our fields. What we need is our month flag. Let's add this to…
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.