CODEWITHSUNDEEP
excelpowerpivot
nicolas
nicolas

Reputation: 9805

full table join in powerpivot

In powerpivot, Related(Othertable[field]) retrieves the associated column from a related table.

I would like to import ALL such columns, doing the equivalent of a join.

Is it possible to do this ?

Upvotes: 0

Views: 4473

Answers (1)

Petr Havlik
Petr Havlik

Reputation: 3317

nicolas,

the smartest thing to do from my perspective is to merge your queries into one so that you can keep your original tables.

I would suggest using new PowerQuery Merge funcionality, which is very easy and works reliably (and also supports loading data directly into your PowerPivot data model).

Or you can write you custom Query in PowerPivot - if you use MSSQL (or any other) database as your source, you can actually use JOIN directly in the PowerPivot window with Table Import Wizard that makes things a bit easier.

So the answer is: keep your original data tables intact, and create a new one that will be merging them together just for the purpose of your desired report.

Hope this helps.

enter image description here

Upvotes: 1

Related Questions