Forum Discussion
Issues with LOOKUP
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 her...
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...
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.