Forum Discussion
gltech
Jul 07, 2020Copper Contributor
queries and merging
Hi Team, I am supposed to compare data from sold by category and manufacturer, this data is stored in two different tables: Purchases and Products... I am stuck with what to do and how to link them.....
- Jul 07, 2020
You don't need to merge queries. Load tables to data model and follow the instruction literally, starting with Section 2 (create relationships).
gltech
Jul 07, 2020Copper Contributor
SergeiBaklan Ok, I understand that part, but how do I load the two separate tables into a data model? I know how to load one, but in order to load both do I need to paste both data tables onto the same sheet and use that?
SergeiBaklan
Jul 07, 2020Diamond Contributor
If you Power Query the data, no need to load table into worksheet. You shall have two queries for two tables. In queries pane right click on query name, select Load To and choose correct option.