How to calculate the kilometers (readings in same column), different events.

[neveld]

Hi, Folks!

I need help with the code to calculate the kilometers between two services.

the readings are in the same column (data for several vehicles) with diferrent dates.

Looking forward to hearing from you.

Regards,

Luis Neves

[amitchandak · Accepted solution]

@neveld ,

New column =

Var _max = maxx(filter(Table, [vehicle] = earlier([vehicle]) && [Kms] < earlier([Kms]) ) ,[Kms]) 

return

[kms] -_max 

[neveld]

Thank you very much!!!