Find a number of units int the latest transactions for unique account-asset pairs (array)

Hello, I'm the first timer in the forum. I'm trying to generate a report utilising office 365 dynamic arrays using LET function.
The date source is a large file containing transactions with columns Date, Account, Asset and Units. I want to report the latest number of units per unique Account-Asset -pair. It's easy to generate dynamic unique list of Account-Asset pairs with UNIQUE function. And I also manage to calculate the correct value, if I use XLOOKUP on the column next to my spilling array, and copy my formula down, but that's not dynamic. I cannot figure out how to make it dynamic. Is it even possible?
See my sample data in the attachment.

Thank you very much your assistance beforehand. I would love to solve this puzzle.

I3=IFERROR(INDEX(tblTransactions[Units],MATCH(AGGREGATE(14,6,tblTransactions[Date]/(tblTransactions[Account]=G3)/(tblTransactions[Asset]=H3),1),tblTransactions[Date],0)),"")

Copy down

Thx CARACALLA, your suggestion works, as well as
I3=IF(G3<>"";XLOOKUP(TODAY();(tblTransactions[Account]=G3)*(tblTransactions[Asset]=H3)*(tblTransactions[Date]);tblTransactions[Units];;-1;-1);"")
with a small improvement.
But neither of those are exactly what I am looking for. I would love to have a single cell implementation without copying the formula down. There are two reasons: 1) my excel is quite large and complex, and I would like to improve it performance. 2) I would like to understand what I am after is even possible. I did not manage with it by myself.