Currency Conversions Per Row

[BenGWeeks]

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?

[amitchandak · Accepted solution]

@BenGWeeks , check this one from radcad to get conversion data using APIs

https://radacad.com/currency-converter-power-bi-function-part-1