Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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 |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |