Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?

 

 

DAX
DAX Calculation
DAX Commands and Tips
Need Help DAX

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous 

    How can the rankvalue be -1??

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous ,

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

    Best Regards,
    Community Support Team _ kalyj