LOOKUPVALUE returns blank value

Hi,

I'm facing a problem where i use lookupvalue formula with 2 values and returns blank value, and need help on this.

I have 2 tables, with following samples

Table #1

Asset_no     Date           Value1

A                 1-Jan-18      1000

B                 1-Jan-18      200

A                 2-Jan-18      1000

B                 2-Jan-18      210

Table #2

Asset_no     Date           Value2

A                 1-Jan-18      1000

B                 1-Jan-18      250

A                 2-Jan-18      1100

B                 2-Jan-18      210

And i'd like to compare both tables, and expect to have the result in Table #1

result expected:

Asset_no     Date           Value1   Value2_Table2

A                 1-Jan-18     1000        1000

B                 1-Jan-18      200          250

A                 2-Jan-18     1000        1100

B                 2-Jan-18      210         210

Tried to use this formula in this value2 by adding a calculated column:

Value2_Table2 = LOOKUPVALUE(Table2[Value2], Table2[Asset_no], Table1[Asset_no], Table2[Date], Table1[Date]) 

however, the Value2_Table2 returned is blank

I have ensured the data type of Asset_no and Date in both table is the same, and ensure that there's only 1 row to expect in Table2. Need advise what may cause the blank result, and how to correct it.