VLOOKUP other table

[Henrik_99]

Hi 

I have a Maintable with no dublicate WONO. I want to run a vlookup in another table B with dublicate WONO, and want to return 1 if Availability = N exists in table B.

Maintable and Stocktable.

Regards

H.

[v-piga-msft · Accepted solution]

Hi @Henrik_99,

In Power BI, you can write DAX to look up value in different tables, you can take a look at the following similar thread to get more details.

http://community.powerbi.com/t5/Desktop/IF-VLOOKUP-ISNA-gt-DAX/m-p/229722#M102430 

If you still need help, please share your sample data as tables and your desired output so that we can further investigate on it?

Best Regards,

Cherry