Create new column with exchange rate conversion

[romovaro]

HI all,

I have a question regarding echange rate conversion.

I have my data source Excel with the columns below:

CUID. Unique customer number

Currency used

Start value: Total amount

I am struggling to create a formula combining the 3 columns. THe idea is to create a new column showing

If CUID is in USD, then we leave the same number. USD do not change

IF CUIDS in in EUR, then we use a conversion rate of (1.13 example)

IF CUID is in GBP, then we use a conversion rate of (1.11 example)

thanks

[romovaro · Accepted solution]

Find a solution that works for "fix" exchange rate.

Created a table with the currencies Used 

Linked to my other table

and used the formula below:

TOTAL usd = SUMX('PV Celergo Report',

'PV Celergo Report'[Start Value]*

LOOKUPVALUE('Exchange Rate'[Conversion rate], 'Exchange Rate'[Currency], 'PV Celergo Report'[Currency]))

How To Work With Multiple Currencies In Power BI - Microsoft Power BI Community

Thanks

TOTAL usd = SUMX('PV Celergo Report',

'PV Celergo Report'[Start Value]*

LOOKUPVALUE('Exchange Rate'[Conversion rate], 'Exchange Rate'[Currency], 'PV Celergo Report'[Currency]))