Forum Discussion
PowerPivot Table
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!
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
3 Replies
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 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