I am seeking for a small explanation.
I wrote a formula to convert DKK to Euro.
Euro Revenue = SUMX(Charges,Charges[Gross Amount] * LOOKUPVALUE(‘Exchange Rate’[EUR],‘Exchange Rate’[Date],Charges[Invoice Date]))
If I understand correct Each individual row will be multiplied by the converted exchange rate.
0.1342 is the exchange rate for the below dates.
I am not 100% sure if the answer is correct or this is due that SUMX multiplies each line by the rate and that why the answer is slightly different.
1,062,168.8800 142,649.2800 = 0.1343
whereas 1,062,168.8800 * 0.1342 = 142,543.0637