Forum Discussion
Using Inner Join Merge to create a new tble that filters in sales data frm table of unique customers
Im trying to create a new table in power query that only shows sales data from a unique list of customers. The unique list of customers are listed on a different table, seperate from the sales table.
Im trying to accomplish this by merging queries using INNER JOIN. Instead of getting a new table filled with only sales data from the unique list of customers, im just getting a duplicate of the original sales table.
Am I wrong for using the merge query function?
You could do a merge query, your two tables. Select the table with the unique customers as primary table, and sales as secondary. Join kind would be All from first, matching from second. Does this work?
3 Replies
CoreyPSolution Sage
Sounds like you could just use a relationship between the two tables, then when you build your visualization, you would use your customer field from your "unique customers" table, and the amount field from the sales table. Power BI should only show you the total sales for those unique customers.
Yea I figured I could do the filtering on the report layer, but I wanted to create a dataset to be used by others as well.
- CoreyP
You could do a merge query, your two tables. Select the table with the unique customers as primary table, and sales as secondary. Join kind would be All from first, matching from second. Does this work?