Solved: Populating starting mileage with previous recorded... - Page 2

Gustavo_Leiva · 11-03-2021 03:24 PM

Hello,

I am working through an app has the user enter the mileage at the start and end of day.
I’d like the starting mileage entry to be populated with the previous mileage for that truck.

I have 2 tables, Mileage Form and Trucks.

[Truck Number] from Mileage Form references [Truck ID] from Trucks. I can see the Related Mileage Forms in the Trucks table but I am still having trouble putting together the expression that will pull the previous recorded mileage for that truck in [Starting Mileage] located in the Mileage Form. Any help is greatly appreciated!

Mileage Form:

RowNumber
Record ID
Date
Truck Number → Ref
Starting Mileage
Ending Mileage
User

Trucks
Truck ID
Make
Year
Related Mileage Forms

Gustavo_Leiva

Hello Steve,

Please disregard today’s replies. I continued reading the very helpful thread you shared with me and was able to put together the expression that gave me the results I wanted!

LOOKUP(
MAX(
SELECT(
Mileage Tracker[_ROWNUMBER],
([_THISROW].[Truck Number] = [Truck Number])
)
),
“Mileage Tracker”,
“_ROWNUMBER”,
“Ending Mileage”
)

Thank you very much for all that you do!

Gus

View solution in original post

Populating starting mileage with previous recorded mileage