Forum Discussion
DAX
Hi All, I have attached 2 images below. They are both in the same table, just different regions. The problem is, for the region EMEA, I need to apply exchange rates. Hence I ha...
In that case try using the RELATED() function since it is more efficient and has a better performance than the LOOKUPVALUE(). Something like:
R+ Order Value =
var _plant = RELATED('R+ Orders'[PartPlantbyYearWeekNum])
var _divide = DIVIDE( 'Part File'[PartPlantbyYearweekNum] , 'Part File'[Exchange Rates] )
return
IF(
_plant in { "EMEA", "NA"},
_divide,
BLANK()
)
Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!
Best regards,
Gonçalo Geraldes
Anonymous do you have a relationship between the to table that are being used?
goncalogeraldes the current table name is Part file.
I have the R+ order value in the R+ order table.
I want R+ order value in the part file. hence doing lookup.
Now I want to apply the exchange rate to R + order value, EMEA region.
Both the tables have PartPlantbyYearWeekNum.