Join tables with different column names but that's the same information

[csalinas23]

Estiamdos,

How can I join tables in PBI to keep me as follows:

TABLE 1
Date	Client	Sales	Stock
12/03/2020	AAA	8	9
TABLE 2
Date	Client	Sales	On_Hand
12/03/2020	BBB	8	9
TABLE SEARCHED
Date	Client	Sales	STOCK
12/03/2020	AAA	8	9
12/03/2020	BBB	8	9

Stay tuned

Best regards

[mahoneypat]

In the query editor, just rename your On Hand column to Stock in Table 2.  Then append the two queries using the button on the ribbon.  You will also want to disable load on the two original queries (right click on each and uncheck Enable Load), so that you only load the new appended table.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[csalinas23]

The problem is that the two tables are still separated in the model...

How can I join them to be the same table?

[mahoneypat · Accepted solution]

This needs to be done in the query editor.  Please see this video to see how to do it.

https://www.youtube.com/watch?v=CW-Er8slv9k

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat