Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! goncalogeraldes 

But I am getting an error.

 

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

Anonymous do you have a relationship between the to table that are being used?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.