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?