Forum Discussion
New_hello188
Helper I
Helper ITo return value based on start and end date column with condition.
Hello All , I need to refer to table B and get the appropriate exchange rate for a transaction based on the posting date (table A). Ignore the currency code as report need to be presented in SG...
amitchandak
Super User
Super UserNew_hello188 , A new column in table 2
Maxx(filter(Table2, Table1[Currentcy Code] = table2[currency code] && Table1[Date] >= Table2[Start Date] &&( isblank(Table2[End Date]) || Table1[Date] <= Table2[End Date]) ) , Table2[Exchnage_Rate])
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8