Forum Discussion

BenGWeeks's avatar
BenGWeeks
Regular Visitor
5 years ago
Solved

Currency Conversions Per Row

Hi all,

 

If I have the following columns:

 

Date, e.g. 02/02/2021
Cost, e.g. 100
CurrencyUnit, e.g. EUR

 

Is it possible to create a new column (called CostDollars) that uses a function to call a service to give me the total cost for that date in USD? E.g. = CurrencyConversion(Date,Cost.CurrencyUnit,"USD")? (without having to track currency conversion rates within the model as new data itself, ref: Multiple Currency Logic In Power BI - A LOOKUPVALUE Example | Enterprise DNA and Currency conversion in Power BI reports - SQLBI). IF we do need a currency conversion table, is there a service that can be recommend to pull this in from to a table?