Forum Discussion
Merging with criteria
I have a table with financial information that has multiple dates in it, and another table with conversion rates by month that I would like to merge to the financial table. The problem is that I woul...
Anonymous , In such case we create a calculated column
new column in table 1
=
var _date = maxx(filter(Table2, table2[Date] <= table1[Date]), Table2[Date])
return
maxx(filter(Table2, table2[Date] =_date), Table1[Exchange Rate])we can add more condition like from currency , to currency
amitchandak
Super User
Super UserAnonymous , In such case we create a calculated column
new column in table 1
=
var _date = maxx(filter(Table2, table2[Date] <= table1[Date]), Table2[Date])
return
maxx(filter(Table2, table2[Date] =_date), Table1[Exchange Rate])
we can add more condition like from currency , to currency
Ok thanks for the reply, I'll try that. Would creating a calculated column make more sense than a DAX measure to achieve the same thing?