I am currently facing difficulties creating a DAX measure(or python script, or something else) to calculate the local distance between the most recent activity and the previous one, with all the data already present in a single table. Despite extensive research, all the examples I’ve found involve two tables, which doesn’t apply to my situation.

The table contains the following columns: the ID of the card that performed the activity, the activity ID, the location ID, the registration date (note that an activity may start on the 10th, for example, but the relevant date is the end date, so in this case, the date would actually be the 11th), start and end date/time, latitude, and longitude.

The goal is for the user to be able to filter the data by the card ID and then by the registration date. Once filtered, the data should be organised by date and time, and the measure I intend to create should calculate the distance from the location of the previous record.

I realise this might sound a bit confusing, so let me clarify with some example data:

Let’s suppose that these are the data stored in the database.
Now I will show what the user will see when filtering on the dashboard.

This is what the user will see when applying the filters; the .distanceKM will be calculated in the order of the records.
I hope this is enough for you to understand my question. I look forward to the resolution of this issue or even a suggestion.

P.S.: I had to create random data to protect confidential information, but I think the idea is clear.