Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
1) Opportunity (2) - has Amount and CurrencyIsoCode fields. Amount is in local currency
2) Currently Type - has IsoCode and ConversionRate fields.
CurrencyIsoCode and IsoCode is the same field that has currency codes (USD, EUR, etc)
How to I create a measure or a calculated column with the converted amount?
Thanks ya'll in advance!
Solved! Go to Solution.
I just figured it out!
Amount in USD 3 = SUMX('Opportunity (2)', RELATED('Currency Type'[ConversionRate])*'Opportunity (2)'[Amount])
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
I just figured it out!
Amount in USD 3 = SUMX('Opportunity (2)', RELATED('Currency Type'[ConversionRate])*'Opportunity (2)'[Amount])
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |