Currency Converter

I've recreated your situation with the following tables:

Table TransactionsTable CompanyMasterTable CurrencyRates

PowerBI automatically created relationships. If this is not yet the case in your report, then create relationships Transactions[CompanyID] and CompanyMaster[CompanyID], and a relationship between CompanyMaster[Currency] and CurrencyRates[Currency]

Now, there are a few ways to get to your result, but what I've chosen to do was add a calculated column to the Transactions table:

AmountUSD = Transactions[AmmountLocalCurrency] * RELATED(CurrencyRates[RateUSD])

What is happening here is that it will look for the related RateUSD for every transaction. This is done through the relationship with CompanyMaster, and then furthermore with its relationship with CurrencyRates. This results in the following table (from the data view):

Note the additional column AmountUSD

Now you can use your Transaction table to create reports in just one currency (USD, in this case).

If this answered your question, please mark this as the solution.