How to make measure, based on local currency to go to different data source and to multiple the FX

[Anonymous]

Dears, 

I need help creating a measure, which based on the currency name, used the relevant FX rate and convert it to USD. The FX rates and Amount in Local currencies are from different data sources. They are linked with a unique key.

Can you please help

[amitchandak]

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

You can also refer to these Solutions

currency
https://www.youtube.com/watch?v=4dosxfNxR6M
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-converter-power-bi-function-part-1
https://www.youtube.com/watch?v=Q4hF4CwJsFEhttps://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2
https://businessintelligist.com/2015/03/17/power-bi-tutorial-how-to-implement-currency-conversion-using-power-query-and-power-pivot/
https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi