Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
UB400
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
Floriankx
Solution Sage
Solution Sage

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

View solution in original post

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

View solution in original post

2 REPLIES 2
Floriankx
Solution Sage
Solution Sage

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 Thank you very much, really appreciated. I used the Calculated Column and it worked a treat.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.