Forum Discussion
Calculating time difference
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?
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.