Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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) : ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    MiraAciu
    Regular Visitor
    5 years ago

    Hi,

    Import a history rate table instead the one you have.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        MiraAciu
        Regular Visitor
        5 years ago

        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,