Assistance Needed with DAX Measure for Calculating Sequential Distance in Power BI

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.

Try a Measure similar to:

.distanceKM = 
  var thisLat = MAX('YourTable'[LATITUDE])
  var thisLng = MAX('YourTable'[LONGITUDE])
  var prevRow = OFFSET(-1, DISTINCT(ALLSELECTED('YourTable')), ORDERBY([ENDTIME], ASC))
  var prevLat = CALCULATE(MAX('YourTable'[LATITUDE]), prevRow)
  var prevLng = CALCULATE(MAX('YourTable'[LONGITUDE]), prevRow)

  // from 2nd answer at https://stackoverflow.com/a/21623206/21688343
  var r = 6371 // Earth's radius in KM
  var p = DIVIDE( PI(), 180 )
  var a = 0.5 - DIVIDE(COS( (thisLat - prevLat) * p), 2) + COS(prevLat * p) * COS(thisLat * p) * DIVIDE(1 - COS((thisLng - prevLng) * p), 2)
  var dist = 2 * r * ASIN(SQRT(a))

  return IF(NOT ISBLANK(prevLat), dist, 0)

The main part is using OFFSET to get the previous row. See https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/ for a good write-up on it.