Forum Discussion

annamill's avatar
annamill
Regular Visitor
9 years ago
Solved

Currency conversion question

I am very new to Power BI and I need help with converting my total amounts from the Local Currency to USD based on the conversion rate (which is in a different table)   I have two related tables: ...
  • annamill's avatar
    annamill
    9 years ago

    I just figured it out!

     

    Amount in USD 3 = SUMX('Opportunity (2)', RELATED('Currency Type'[ConversionRate])*'Opportunity (2)'[Amount])

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi annamill,

 

You could try this formula. I created a sample as the picture showed. (There isn't a relationship between these two tables.)

 

AmountInUSD =
[Amount] * LOOKUPVALUE ( CurrentlyType[Rate], CurrentlyType[ISOCode], "USD" )

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale