cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

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

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.

2 ACCEPTED SOLUTIONS
Solution Sage

Hello,

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

Regular Visitor

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

2 REPLIES 2
Solution Sage

Hello,

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

Regular Visitor

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors