Forum Discussion
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.
Regards
H.
Hi Anonymous,
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#M102430If 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
1 Reply
Hi Anonymous,
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#M102430If 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