From the course: Excel: Working Together with Power Query and Power Pivot
Join today to access over 24,700 courses taught by industry experts.
Scenario 2: Updating queries
From the course: Excel: Working Together with Power Query and Power Pivot
Scenario 2: Updating queries
- Sometimes it's only when you start to analyze your data that you notice that something isn't quite right. This may be a problem with the actual source data, or it could be something as simple as needing to update the query. The brilliant part about power query is, making a change to an existing query is extremely simple. And with power query and power pivot designed to seamlessly work together, any changes to reports and charts update automatically. Let's go ahead and take a look at the pivot worksheet. If we click on the drop down box next to row labels, you'll notice that we've manually excluded one of the years from our data, which is the year 2020. We did this because at the time we took our snapshot of data, it was an incomplete year and it was making the charts look a little bit strange. Now, if this was the only chart we were to ever produce in our model, then this would be okay. But over time, I'll guarantee you, that…
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.