Does a column of another table contain a certain value?

[iiomarioii]

Hi guys, 

i have these tables: 

Inventory 1: 

Item number	Quantity	...
1022	10	...
2022	20	...
3033	30	...

Inventory 2: 

Item number	Quantity	...
1022	10	...
2022	20	...
1111	30	...

I need a column that shows me wheater 'Inventory 2'[Item number] contains the Item numbers of 'Inventory 1'[Item number] or not.

So for example like a new column in Inventory 1: 

Inventory 1: 

Item number	Quantity	Comparison
1022	10	true ( exists also in Inventory 2)
2022	20	true
3033	30	false

All item numbers are strings. 

Any solutions for this? 

Thank you 🙂

[ryan_mayu · Accepted solution]

@iiomarioii 

you can use LOOKUPVALUE that Greg suggested or you can also try this

Column = if(MAXX(FILTER('inventory2',inventory2[itmenumber]=inventory1[itemnumber]),inventory2[qty])=inventory1[qty],"True","False")

[Greg_Deckler]

@iiomarioii - In general, use LOOKUPVALUE. You can also use techniques such explained here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434 and here: https://community.powerbi.com/t5/Quick-Measures-Gallery/LOOKUPVALUE-Range/m-p/974201#M430