Calculate the difference between km for th same car

[Anonymous]

Hi everyone,

I would like to find an issue to look for the last "km d'arrivée" for the same car.

Here are my datas ("immatricultion" is the car plate reference, "kmde départ" and "kmdarrivée" are the km from the start and the end of the route, "datederetour" is the date when the user came back with the car) :

I would find out the difference between 132000 and 131487...one value per row to highlights the row which are wrong (difference not null).

Do you know what I mean? 😉 

I tried with summarize, with max, dateadd, earlier, filter...

Thank you for all your support,

Baptiste

[VasTg]

@Anonymous 

Could you post some sample data? Is my understanding correct?

Plate	Start	End	Expected Difference?
abc123	19350	20450	1100
xyz123	54000	55000	1000

[Anonymous]

No, sorry,

My picture didn't appear, sorry.

Here is it :

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-o...