Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to match and get value from another table

I have two tables:   Table A Driver_Name ,Date , total_order   Table B  Driver_Name,Date ....     Now i want to i want to insert the value from table A when driver name and date are matched....
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    You could add a calculated column in Table B via Lookupvalue funcion.

    New Column =
LOOKUPVALUE (
    TableA[total_order],
    TableA[Driver_Name], TableB[Driver_Name],
    TableA[Date], TableB[Date]
)

    Best regards,

    Yuliana Gu

PoRoBi's avatar
PoRoBi
New Member
3 years ago

I tried to use your formula but for some reason my tableB cannot be enterred/recognised. Any suggestions?

Thanks

duardo08's avatar
duardo08
Icon for Advocate I rankAdvocate I
3 years ago

Here it worked. The tables have to be related by some column