Forum Discussion

Hakha's avatar
Hakha
New Member
4 years ago
Solved

LOOKUPVALUE

Hi everyone, I have trouble using the LOOKUPVALUE function as the expected result shows up empty and appearently "not found". the two tables share a column with the almost exact data. I'm trying to ...
Need Help
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello Hakha ,

     

    Ideally it should give you correct result. Might be data issue.

     

    Can you please use Len('Scale'[Currency]) and Len('Hollow Knight'[Currency]) and check length is coming same for Argentina Peso in both tables. Might be extra blanks in starting or ending of data.

     

    Cheers,

    Shishir

     

Shishir22's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
4 years ago

Hello Hakha ,

 

Ideally it should give you correct result. Might be data issue.

 

Can you please use Len('Scale'[Currency]) and Len('Hollow Knight'[Currency]) and check length is coming same for Argentina Peso in both tables. Might be extra blanks in starting or ending of data.

 

Cheers,

Shishir