cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henrik_99 Regular Visitor
Regular Visitor

VLOOKUP other table

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.

 

Maintable.JPGStockprice.JPG

 

Regards

H.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: VLOOKUP other table

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: VLOOKUP other table

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.