Return closest value less than given number matching another column - Power Query ?

Hello all,

I have got a workbook of three huge tables that come into one merging Power Query. Unfortunately I'm not very good at it as I just discovered it but already seen its benefits. Merging them three tables using functions would make calculation time extremely long.

Columns A to E is a part of a original table.
Column F checks what was the last trip id for the given name.
Column G returns the last trips arrive mileage.
Column H returns the difference between last trip arrive mileage and current trip depart mileage.
Column I returns 1 if the difference is lower than 10 miles.

Note: trip id's are not in the order so as date is not either.

The question is:

Is it possible to return result shown in column I using power query? From experience with power query i think this would be the most optimal option to calculate through data rather than using functions.



power_query.JPG