课程: Excel: Working Together with Power Query and Power Pivot

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

Import additional data

Import additional data

课程: Excel: Working Together with Power Query and Power Pivot

开始一个月试用 购买团队方案

Import additional data

“

- [Instructor] To get the full value out of PowerPivot, we need to import another data source and link the two together using something called a relationship. And we'll come to this in a moment. You'll notice here on the worksheet called LOC type that we have a simple table with two columns, location and type. The location is simply a list, a unique list of locations that match, or at least it should match what appears here in column K. If we go back now to the worksheet called LOC type, you'll see that we have a second column, which is called type, and this is simply a classification that I've created myself. And that's allowing me to tag the location as either being a city or a town. And eventually when we've linked to these two together, we'll be able to do some fancy slicing and dicing of our data. But before we can do that, we actually need to add this table into our data model. And this is really simple.…

内容