Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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)
Proud to be a PBI Community Champion
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.
@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...
Proud to be a PBI Community Champion
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |