topic Calculating time difference in DAX Commands and Tips

Calculating time difference

Anonymous — Thu, 28 Oct 2021 07:00:58 GMT

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?

Anonymous — Thu, 28 Oct 2021 07:53:32 GMT

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 — Thu, 28 Oct 2021 10:17:02 GMT

Anonymous

How can the rankvalue be -1??

v-yanjiang-msft — Tue, 02 Nov 2021 06:00:32 GMT

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 — Mon, 01 Nov 2021 13:13:17 GMT

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?

v-yanjiang-msft — Tue, 02 Nov 2021 06:08:38 GMT

Hi Anonymous ,

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

Best Regards,
Community Support Team _ kalyj