Calculating time difference

[Anonymous]

I have the following table:

I want to add a column that calculates the time difference in hours between each consecutive Updated Date column.

How do I do that?

[v-yanjiang-msft]

Hi @Anonymous ,

I revised the previous reply, you can refer to it.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, here’s my solution.

1.Create a calculated column by the rank of UpdatedDate.

RANK = RANKX('Table','Table'[UpdatedDate],,ASC,Dense)

2.Calculates the time difference.

3.You can also use a card visual to display the sum of time difference.

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

@StenbergAleksi 

How can the rankvalue be -1??

[StenbergAleksi]

Hello @Anonymous ,

First create the order with RANKX and then you can do datediff where you filter the second time value rankvalue is  -1

[Anonymous]

Hey @StenbergAleksi 

I actually want the Sum of all those differences of consecutive rows in a measure to display in a card visual.

How do I do the same?