Currency Change (Dynamically by Date and Currency Code)

[Galat198]

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 ??

[v-yiruan-msft · Accepted solution]

Hi @Galat198 ,

Please review the content in the following blog, hope it can help you.

Scrape Data from Multiple Web Pages with Power Query

Best Regards

[Galat198]

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 @amitchandak 

[amitchandak]

@Galat198 , 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])

[Galat198]

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?

[MiraAciu]

Hi,

Import a history rate table instead the one you have.

[Galat198]

Hi @MiraAciu 

Hi,
May you know where I can find an updated rates table with dates ??
On xe.com only this table.....
No must be live, only daily rates of all currencies.

Thanks ))

[MiraAciu]

On xe.com I see you can change the date. You can practice with 2-3 dates from there for now, copying small sets of results into a file and use it as a source for your report. You can add more dates lately.

[MiraAciu]

This can be quite a challenge for me, in my country I can acces the history on the official site of the National Bank :). I presumed you can have access to your company database and there you can find the desired history. I'll try to find something for you. Or maybe someone else can help you more,