Forum Discussion
Currency convertion
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?
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
2 Replies
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
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] )))).
