confused about relationships to appended query

Guitarmageddon

Board Regular
Joined
Dec 22, 2014
Messages
78
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?
 

Forum statistics

Threads
1,086,243
Messages
5,388,663
Members
402,133
Latest member
wilt823

Some videos you may like

This Week's Hot Topics

Top