Forum Discussion
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. ...
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.
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.
Hi,
I still do not understand. Someone else will help you. Sorry.