Forum Discussion

BlastS's avatar
BlastS
Helper I
7 years ago

Calculate Duration Datetime and Sum

Greetings, i am trying to get a duration of a single column which contains the datetime and after that i need to sum that duration between the dates i want to get which i gona show in a example.   ...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

In a spare column, share the exact result you are expecting.

BlastS's avatar
BlastS
Helper I
7 years ago

Ashish_MathurThis is something very siilar that i planned to get ,but i want to get sum the duration of the datetime inside the purple area in my image. like he got between failures.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    That is not what i am expecting from you.  I want the exact numeric answer you are expecting.  Once i write my DAX formula, i will then compare my answer with yours.

    • BlastS's avatar
      BlastS
      Helper I
      7 years ago

      Ashish_Mathur

       

      This is a example of an expected output:

       

      AverageTimeFailure
      2Days10Hours20min

       By Sum the duration of each date duration inside purple area it will give that.

       

      Basically the column will be that AverageTimeFailure (Sum(All durations inside purple area and next divide by the number of fails), hope i helped you with this.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        I still do not understand.  Someone else will help you.  Sorry.