Formula to retrieve different column result if condition met

[jimpatel]

Hi,

I have 2 tables and i am having really hard time in linking it.

Two tables have several partnumbers (repeated as well) but not identical. Is there any formula to find if Table 2 partnumber match with Table 1 partnumber if yes then i wanted to retrive "Column D" data from Table 1 please.

Thanks

[jimpatel]

Thanks for your reply. When i use below formula, i am getting an error as table of multiple values was supplied.

When i try to retrive "Formula column"  i am getting this error, any idea please?

Column 3 = LOOKUPVALUE('Level'[Number],'Level'[Com],'Order'[Material])

[jcalheir]

Hi

You are looking for LOOKUPVALUE. Check the documentation bellow and the attached video.

https://docs.microsoft.com/pt-pt/dax/lookupvalue-function-dax

https://www.youtube.com/watch?v=jUaEdwN9J1I

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂