Forum Discussion
Currency Change (Dynamically by Date and Currency Code)
Hi,
I have a table like this :
This may be a Table with all types of currencies of the world. Currently, I connected to xe.com but the table is without dates (update by the last date) :
How I can dynamically change each currency to USD by currency code and their rate on a specific date ??
Hi Anonymous ,
Please review the content in the following blog, hope it can help you.
Scrape Data from Multiple Web Pages with Power Query
Best Regards
8 Replies
Anonymous , Try a measure like
Sumx(summarize(Table, Table[Date], [Currency], "_1",sum(Table[Amount])* if(max(Table[Currency])= "USD",1, maxx(filter(currency,currency[Code] =max(Table[Currency])),currency[unit in USA]))), [_1])Thanks for your response,
But I need to change the rate on the same date as the amount.
So if the date is 01/01/2021 in need to get a rate of EUR to this date, but in the currency table rates only for today.Because the EUR rate in 01/01/2021 maybe 0.8, but today it may be 0.9, so I need change to USD by 0.8
Is it possible?
Hi,
Import a history rate table instead the one you have.
Via National Banks is possible only for main currencies.
But I need all currencies (around 170)From https://www.xe.com/currencytables/?from=USD&date=2021-01-19 it's only for a specific date or last date or static historical excel file (need manual update daily).
Somebody know any way to get daily updated historical currency rates?? free 😉
MiraAciu amitchandakHi Anonymous ,
Please review the content in the following blog, hope it can help you.
Scrape Data from Multiple Web Pages with Power Query
Best Regards
