Forum Discussion

shaan_khokhar's avatar
shaan_khokhar
Regular Visitor
7 years ago

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 here:

 

 

Any help is appreciated Smiley Happy

Need Help

4 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    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's avatar
      shaan_khokhar
      Regular Visitor
      7 years ago

      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's avatar
        PattemManohar
        Community Champion
        7 years ago

        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...