Sum from other table when previous row is smaller than the following row

[reggieneo]

Hello again,

Kindly assist with this: I would like to sum sales when the previous row is smaller than the row below it.

in the image attached, 3479 is smaller than the immediate row below it 5361 so the expression should calculate the sum.

Sum(SELECT(
Sales[Diesel Liter Sales],
[Timestamp] >= MAX(
SELECT(
Sales[Timestamp],
([Diesel Opening Dipstick] >[Most Recent].[Diesel Opening Dipstick] )))))

my expression is giving me an error of unable to find the column “[Diesel Opening Dipstick]” of [Most Recent].[Diesel Opening Dipstick].
thanks.