Forum Discussion

BlastS's avatar
BlastS
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper 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
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

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