How to convert foreign currencies to U.S. dollars

[dreaves1]

Hello Power BI community,

I have two tables. One is a currency exchange table that has two columns. One column is the currency and the other column is the exchange rate to U.S. dollars. I have a second table that includes invoices amounts from different countries with different currencies included. The currency format is the same in both tables. How can I create a formula that converts all the differenct currency entries into U.S. dollars?

Thank you!

[Anonymous · Accepted solution]

Hi @dreaves1 ,

Create a measure like below.

Measure = 
var _rate = CALCULATE(MAX('currency exchange'[exchange rate]),FILTER('currency exchange','currency exchange'[exchange currency] = SELECTEDVALUE('Table'[currency])))
return
SUM('Table'[sales])*_rate

Best Regards,

Jay

[amitchandak]

@dreaves1 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try to create a new column

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

or refer these

https://www.youtube.com/watch?v=9oPFgHvGyKc
https://blog.enterprisedna.co/how-to-download-latest-exchange-rates-into-your-power-bi-model/
https://radacad.com/currency-converter-power-bi-function-part-1
https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2