Currency convertion

[Digger]

I have table converted by EUR

Now i need add column and convert to USD

So one possible way is find each day USD rate and divide  USDrate = 1/amount_2, and after divide each currency by USDrate

So how to write right formula in transform data?

[amitchandak · Accepted solution]

@Digger , You can get the rate of USD for each date like

in a column

maxx(filter(Table, [date] = earlier([Date] && [Name_2] = "USD") , [Amount_2] )

then you can create formula

[Digger]

@amitchandak  sorry but your formula is wrong
The syntax for 'Table' is incorrect. (DAX(maxx(filter(Table, [date] = earlier([date] && [name_2] = "USD") , [amount_2] )))).