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
BlastS's avatar
BlastS
Helper I
7 years ago

UpdateInfo:

 

First Step off getting the duration is already done, which i achieve this using this : 

Duration = IF(DATEDIFF(LOOKUPVALUE(X[Time],X[Index],X[Index]-1),X[Time],MINUTE)>720,BLANK(),DATEDIFF(LOOKUPVALUE(X[Time],X[Index],X[Index]-1),X[Time],MINUTE)) 
 
2Step now is where it becomes hard, since i want to sum the duration from the time inside that purple area i dont have aclue how to make this here. Is like i want to put, for example, SUM(Duration FROM TIME WHERE LINE IS 1) .
 
 
The Row(Line) that makes the purple area you can watch on the image have values 0 and 1, meaning that when is 1it makes the purple area when is 0 dont exist area.
 
 
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Try this measure

 

=SUM([Duration])

 

Hope this helps.

    • 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.