Perform calculation on two different tables

[Daveed1973]

I have two tables in Power BI Desktop...

Table1

Product   Site   QuantityA

Product1 Site1 100

Product2 Site2 200

Product3 Site3 300

Table2

Product   Site  QuantityB

Product1 Site1  4

Product2 Site2  20

Product3 Site3  37

I need to be able to perform a calculation where the products and sites from table1 that match in table2 are then calculated by QuanityA - QuantityB / QuantityA * 100.

Haven't a clue how to do this. Any help would be appreciated.

[v-yuezhe-msft]

@Daveed1973,

Glad to hear the issue is solved. You can accept your reply as solution to close this thread.

Regards,

[Daveed1973 · Accepted solution]

Okay, managed to do this without too much of a complicated calculation.

I created a new merged table in Power BI Desktop which merged table 1 and table 2 together on the Product and Site columns. Then, as the QuantityA and Quantity B columns are now in the same table I was easily able to perform the calculation.

Think I was trying to over complicate this originally.