Solved: PowerPivot Table

Anonymous · ‎01-31-2019

Hello Everyone, I'm using PowerPivot at the excel (Not on the Desktop App),

What I'm trying to do is to create a PowerPivot table with Data from 2 diffrent tables. I Tried to create a releationship between the tabels with the Seller name, but i got an error message (need a monovalent coulmn).

Thanks Guys!

Stachu · ‎01-31-2019

the easiest way is to have 3rd table with all the unique Seller Names and do joins from that table (you can do that in Power Query/Get & Transform in the Data ribbon if you use Excel 2016)

or you could append table 1 & 2 but first adding an identifier column for type of sale

Sale Type	Seller Name	Amount
regular	John	607
regular	Ben	834
WIP	John	503
WIP	Ben	456

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

Stachu · ‎01-31-2019

the easiest way is to have 3rd table with all the unique Seller Names and do joins from that table (you can do that in Power Query/Get & Transform in the Data ribbon if you use Excel 2016)

or you could append table 1 & 2 but first adding an identifier column for type of sale

Sale Type	Seller Name	Amount
regular	John	607
regular	Ben	834
WIP	John	503
WIP	Ben	456

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous · ‎02-01-2019

Hey Stacho, thanks for your comment!

Actually there is a database behind the tables, each database has a lot of sales lines that I agreed to the pivot table. Thats why I'm trying to do that in PowerPivot tool.

Stachu · ‎02-01-2019

that's perfectly fine, you can still connect to the database and make this kind of changes

best way to do it is with Power Query (so you don't have to copy & paste anything). If you're using PowerPivot connections then I'd recommend rebuilding them in PQ

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂