Calculating time difference

Anonymous · ‎10-28-2021

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 · ‎11-01-2021

Hi @Anonymous ,

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

Best Regards,
Community Support Team _ kalyj

v-yanjiang-msft · ‎11-01-2021

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 · ‎10-28-2021

@Anonymous

How can the rankvalue be -1??

Anonymous · ‎10-28-2021

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 · ‎11-01-2021

Hey @Anonymous

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?

Helpful resources