Can't get table relationship working in the Data Model

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,314
Reaction score
38
Points
48
Excel Version(s)
365
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:
2021-05-04_185213.png

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:
2021-05-04_185613.png
now I try to use that in a pivot table and get:
2021-05-04_185924.png

Why?!
The second file is too big to attach so here's a link: https://app.box.com/s/5goymq7qbd5i9lg1peiou75xbyqabptc
 

Attachments

  • Exercise1.xlsx
    333.3 KB · Views: 12
Last edited:
Ed - any chance you could explain your suggested solutions instead of just posting links? That would be more helpful. Thanks.
 
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.
 
Back
Top