Forum Discussion
Calculate the difference between km for th same car
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
Anonymous
You may refer to the post below.
3 Replies
- VasTgMemorable Member
Anonymous
Could you post some sample data? Is my understanding correct?
Plate Start End Expected Difference? abc123 19350 20450 1100 xyz123 54000 55000 1000 - AnonymousNot applicable
No, sorry,
My picture didn't appear, sorry.
Here is it :
- v-chuncz-msftCommunity Support
Anonymous
You may refer to the post below.