LOOKUPVALUE returns blank value

[RMV]

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.

[Stachu · Accepted solution]

it's really weird, but your example works fine on my pc, no joins between the tables

are both tables' data types the same? Other than that I cannot think of a reason for it not working on your side

[RMV]

sorry, i have found the problem.

tried to delete this post, but can't since a reply has been posted.

[v-huizhn-msft]

Hi @RMV,

You can share your solution, and mark it as answer. So more people will find workaround clearly.

Best Regards,
Angelia