Need help calculating Currency conversions, looking up Exchange rates from a separate Table

[UB400]

I have the following two Tables:

1. Transactions (Sharepoint Online)

2. CurrencyRates (Excel Table)

The Transactions table has (among others) Columns for CurrencyType and Amount

The CurrencyRates Table has two Columns, CurrencyType and Rate

I want to create a new Calculated Column in the Transactions Table, where I can multiply the Amount with the corresponding Rate from the CurrencyRates table.

Thanks any help with this will be greatly appreciated.

[Floriankx · Accepted solution]

Hello,

I assume you already added those two tables to your Data Model.

So you just have to relate the Currency Type Columns.

Then you can either add a Calculated Column =[Amount]*RELATED([Rate]) 

or you can create a Measure TotalEXR:=SUMX(TransactionTable,[Amount]*RELATED([Rate]))

Best regards

[Floriankx · Accepted solution]

Hello,

I assume you already added those two tables to your Data Model.

So you just have to relate the Currency Type Columns.

Then you can either add a Calculated Column =[Amount]*RELATED([Rate]) 

or you can create a Measure TotalEXR:=SUMX(TransactionTable,[Amount]*RELATED([Rate]))

Best regards

[UB400 · Accepted solution]

@Floriankx Thank you very much, really appreciated. I used the Calculated Column and it worked a treat.