Issues with LOOKUP

[shaan_khokhar]

Hi all

My lookup: 

Exchange rate = LOOKUPVALUE(wh_Currency[Units_per_GBP],wh_Currency[Currency_code],"USD")

is not returning any values despite the table having the values as you can see here:

Any help is appreciated 

[PattemManohar]

@shaan_khokhar Your table has "Currency_code" but not "Currency code" and also same with "Units_per_GBP" (You have missed underscores in the field names)

[shaan_khokhar]

Ah i forgot to update here but that's not the issue as i've already fixed that issue. It appears to be returning a blank value.

[PattemManohar]

@shaan_khokhar I am not able to replicate your issue, it is working fine with the below DAX 

lkp = LOOKUPVALUE(wh_Currency[Units_per_GBP],wh_Currency[Currency_code],"USD")

Please provide bit more details about the issue you are facing with this...

[shaan_khokhar]

I had done the look up in another table but to solve it i had to reload the table i had done it in. I am not sure what solved it.