how to compare two columns from two tables

[allen_sap]

Hello Everyone,

Learning Power BI. This might be probably simple case but i cant seem to get the asnwer

Table 1 

Shop Order	Shop Order Line	Part	SO QTY
196932	1	194-044-P390S	15
196932	2	194-044-P5102S	3
196932	3	194-044-P538S	26
196932	4	194-044-S130S	8
196932	5	194-044-S211S	44

Table  2

Part	INV QTY
194-044-P390S	62
194-044-P5102S	51
194-044-P538S	36
194-044-S130S	14
194-044-S211S	30
194-044-S212S	64
194-044-S213S	66
194-044-S929S	67

Question: 

Calculate column "Availability Status".
Availability Status of each shop order line is determined by whether supply satisfies demand, i.e. Not available = "SO Qty" > "INV Qty".

If i do a simple IF - i get circualur dependency error.

Thanks everyone 

[allen_sap]

Thanks for the reply but having difficulty executing it 

[jgeddes · Accepted solution]

You can try

Availability Status =

var _invQty =

LOOKUPVALUE(Table2[INV QTY],Table2[Part],Table1[Part])

Return

IF(

    [SO QTY] > _invQty,

    "Not Available",

    "Available"

)

as a calculated column in table1