How to calculate endtimestamp for the event if only one date/time column available

[Anonymous]

Hi there,

I am in search for solution to my problem. I believe somebody must have had the same or similar situation therefore your help is greatly appreciated.

I have a table with one date column which consists of date and time and other rows specifiy the activity in the process, it is P2P.

Please find attached below what I have in white table and yellow is what I would like to have.

Many thanks

[v-yuta-msft]

@Anonymous ,

Create an index column in query editor and then create a calculate column using dax below:

Timestamp END =
VAR Current_Index = Table[Index]
RETURN
    CALCULATE (
        MAX ( Table[Timestamp START] ),
        FILTER ( Table, Table[Index] = Current_Index + 1 )
    )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-yuta-msft 

Thank you for the tip. Although I do get the dates in the Timestamp END, the dates I get are the same as the Timestamp START.

Seems that the part with Current_Index + 1 does not work, or at least not as it should. Do you have an advice how to solve this? If needed, I can also provide an example excel sheet.

Many thanks

[v-yuta-msft · Accepted solution]

@Anonymous ,

It works on my side as below, could you please share the sample data for further analysis?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.