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,

 

Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

annamill's avatar
annamill
Regular Visitor
9 years ago

I just figured it out!

 

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