Guitarmageddon
Board Regular
- Joined
- Dec 22, 2014
- Messages
- 161
So I have a workbook with multiple tabs of a sales report. It’s essentially the same report, but just for different departments. I utilized power query to query each tab, and then append it into one. I then send that append to a pivot table so I can combine my multiple sources into one neat table. I would like to bring in “district” which is not in the original sales reports, only store number is. However, I added a reference table to my query that is the list of each individual store #and which district they belong to. How am I able to now create that relationship so that I can slice my resulting table off of that? Do I need to add all to the data model? I have tried under “create relationships, but I don’t think I’m doing it right. Can anyone assist? Or is there a better way for me to pull in my different tabs into one?