cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron

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

1 ACCEPTED SOLUTION
Super User

@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 2
Super User

@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

Post Patron

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.