- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- 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:
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
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
Attachments
Last edited: