Power Query merge with lookup table

Hi,
My (mini) project has 2 parts. The first part, I have already solved. The second part I am stuck on.

Solved first part
I have a transaction table of many stock & option trades. I need to group the transactions by trade group & ticker along with few other columns. I did that using power query and the output is in "XClosed Output" sheet in the way I want.

Second part - Unsolved
The transactions are either in USD or CAD, with an open & closed date. I have an exchange rate lookup table. For the USD transactions, I want to multiply the prices with the exch rate and convert them. I have created a sample output with basic excel formula.

But i am looking for some sort of merge table functionality that will give me the output. Should I explore if something in Dax can make it possible?

try to merge twice XClosedTable with ExchTable by appropriate date then if [Currency] = CAD then multiply [Amt O] * [FXUSDCAD] else if if [Currency] = USD then multiply [Amt C] * [FXUSDCAD.1]

Originally Posted by sandy666

try to merge twice XClosedTable with ExchTable by appropriate date then if [Currency] = CAD then multiply [Amt O] * [FXUSDCAD] else if if [Currency] = USD then multiply [Amt C] * [FXUSDCAD.1]

yes, that would be for the open date, but what about closed date ("Date C" column).

Edit: never mind, figured it out. I can then merge again to add a 2nd column for closed exchange rate. once I have the two exchange rate, rest is easy to add.