Power BI Equivalent of NOT IN in SQL

[geekmachine811]

Hi, I have two tables that I need to do comparison from. One is a Master Table( Table_1) that contains many records and the other (Table 2) only has a certain amount.

I know that if I make a relationship between the two, I'll get data that exists between the two tables. However, I'm stuck in a situation where I just want records that exist on Table_2 but are not on Table_1.

With SQL, NOT IN would work but I don't know how to convert the same in Power BI

[v-eqin-msft]

Hi @geekmachine811 ,

Could you tell me if your problem has been solved by using @DataInsights 's suggestion? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[DataInsights · Accepted solution]

@geekmachine811,

You can do this in Power Query or DAX.

Power Query using a Left Anti join:

DAX caclulated table:

CalcTable = EXCEPT ( Table2, Table1 )