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 releationsh...
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
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.
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