Dax for calculated column to take start time of next row as end time current row

[rpinxt]

So to illustrate:

Is there a way to get with DAX column P (Log Time End).

I saw solution with making two index tables one start from 0 and one from 1.

Then merge and that way get the 2 timestamps on the same line.

Made me think.....should be simpler way...

So is there some dax code to get in the context of Day and User the log time of the next row as the log time end of the current row?

[mickey64 · Accepted solution]

Step 0: I use this simple DATA table below. (I add a 'Index' column in Power Query Editor.)

Step 1: I add a column below.

    Log Time Start = LOOKUPVALUE(LogData[Log Time End],LogData[Index],[Index]-1)

[rpinxt · Accepted solution]

Thanks @mickey64 , so you still would need 1 index table (makes things indeed easier).

You used -1 to get the start time. I used +1 to get the end time.

But there was still one thing to overcome :

You see here when a new user start the end time is not correct of course.

The line of 15:32:37 for user ALHAJJX is the last line of that day for the user so should be blank.

Therefore I made the logic like:

So only when current user (c_user) is equal to next user (n_user) lookup the end time.

Works nicely:

So thanks for putting me in the right direction 😄

[mickey64 · Accepted solution]

Step 0: I use this simple DATA table below. (I add a 'Index' column in Power Query Editor.)

Step 1: I add a column below.

    Log Time Start = LOOKUPVALUE(LogData[Log Time End],LogData[Index],[Index]-1)