Thank you. I think you're right. I will put in a start odometer and end odometer. Can you help me with the formula to retrieve the previous [end odometer] from the previous row? I can use that as an initial value for the [start odometer] for the next...

Update: It looks like it subtracts from the original odometer. I want to subtract from the row above it with the same date.

Table 1 columns [Difference], [Odometer], [Row ID], [Date] modified formula[Odometer] - ANY(SELECT(Table 1[Odometer], [Row ID] = MAXROW("Table 1", "Date", ([Date] < [_THISROW].[Date]))))The result is the current odometer reading. It's subtracting 0.[...