In the attached Exercise1.xlsx there are two tables each on its own sheet.
I loaded them both into Power Query, merged/joined them on Part Number/WO# and loaded to a pivot table.
It works as expected:
Now I don't want to do that!
In Exercise1b.xlsx, I'm trying to learn about setting up relations between the tables in the Data Model, so I get both tables into the Data model and create a relationship, ensuring I've got unique values in one table:
now I try to use that in a pivot table and get:
Why?!
The second file is too big to attach so here's a link: https://app.box.com/s/5goymq7qbd5i9lg1peiou75xbyqabptc
Last edited by p45cal; 2021-05-04 at 07:11 PM.
Ed - any chance you could explain your suggested solutions instead of just posting links? That would be more helpful. Thanks.
Ali
Enthusiastic self-taught user of MS Excel!
https://www.youtube.com/watch?v=y8Z9zmuYrdg
Oh and if anyone ever looks at this video always play at X 2 speed https://www.screencast.com/t/PQaO2mRYuzM
Last edited by Ed Kelly; 2021-05-30 at 02:44 PM.
Ed Kelly,
I'm very sorry, I should have replied much earlier to thank you for your response.
To be truthful, I haven't got around to analysing properly your videos but have every intention of doing so.
regards, p45cal.
Posting Permissions
Reply With Quote
Bookmarks