Hi I'm trying to teach myself power query (going well) and power pivot (not so well).
This seems really basic but doesn't work as i envisaged.
I have two tables loaded to data model.
One has Assembly no, component number and qty per ( components can repeat)
The second table is a unique list of components) and price.
I relate the tables on component field and create a pivot table with assembly, component and price and expected to get the price for the part ( i can pull the price across using related, but not the point). Instead under the component i get all the prices listed. WHy?
Obviously must be a misunderstanding on my part of how this should work
Thanks for any pointers
This seems really basic but doesn't work as i envisaged.
I have two tables loaded to data model.
One has Assembly no, component number and qty per ( components can repeat)
The second table is a unique list of components) and price.
I relate the tables on component field and create a pivot table with assembly, component and price and expected to get the price for the part ( i can pull the price across using related, but not the point). Instead under the component i get all the prices listed. WHy?
Obviously must be a misunderstanding on my part of how this should work
Thanks for any pointers