Sumproduct equivalent

[reggieneo]

Hi All,
I am using this expression to get the most recent value based on some criteria. i always ended up to the last value in column:
ANY(
SELECT(
Order Details[Dipstick Closing],
(
[timestamp]
= MAX(
SELECT(
Order Details[timestamp],
AND( ([timestamp] < [_THISROW].[timestamp]),[Product Name]=[_THISROW].[Product Name])
)
)
)
)
)

please help again thanks.