How to match and get value from another table

[Anonymous]

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.

What should i do for this?

[v-yulgu-msft · Accepted solution]

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]

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

Thanks

[duardo08]

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

[mwegener]

Hi @Anonymous

use Power Query "Merge Queries"