Forum Discussion
romovaro
Responsive Resident
Responsive ResidentCreate new column with exchange rate conversion
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...
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]))
romovaroResponsive Resident
Responsive ResidentFind 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]))