LOOKUP Currency with calculation

[rphang]

Hi there, 

I am trying to convert my sales in different counter (with different currency) to the company currency. I have 2 table below and I am using this, however I dont think my DAX is correct as it is giving me different results,

EUR Val = ROW("LOK",[(Local)]) / LOOKUPVALUE('Exchange Rate'[21 Rates],'Exchange Rate'[Currency],ROW("Curr",[Currency]))

Table Name: Total SEA

Currency	Item	(Local)
USD	Product 1	53
USD	Product 2	75
USD	Product 3	29
USD	Product 4	37
USD	Product 5	37
USD	Product 6	218
MYR	Product 1	173
MYR	Product 2	173
MYR	Product 3	212
MYR	Product 4	414
MYR	Product 5	414
MYR	Product 6	1518
SGD	Product 1	61.6
SGD	Product 2	61.6
SGD	Product 3	554.4
SGD	Product 4	61.6
SGD	Product 5	61.6

Table Name: Exchange Rate

Currency	21 Rates
SGD	1.578
USD	1.113
THB	36.21
MYR	4.793

Any help is much appriciated.

[amitchandak · Accepted solution]

@rphang , Create a new column like

EUR Val = maxx(filter('Exchange Rate','Exchange Rate'[Currency] = SEA[Currency]),'Exchange Rate'[Rates]) * SEA[Local]

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8