Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX Help - Time Duration Sum when the date switches

Community, 

Hello, I'm fairly new to using the "Time" calculations in DAX and am looking for some help.

 

I have a DAX expression that is correctly delivering the duration of two times correctly, but when switching from AM to PM (Run ID 13 below) I get a duration that is the length of almost 24 hours. Below is the DAX as well as the table/data delivered

 

Wind On Duration = IF(
    HASONEVALUE(COEF_DATA[Run ID]),
    CALCULATE(MIN('TIME DATA'[Time])-MAX('TIME DATA'[Time])),
    SUMX(VALUES(COEF_DATA[Run ID]),
    CALCULATE(MIN('TIME DATA'[Time])-MAX('TIME DATA'[Time])))
    )

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
The date changes during Run ID 13, I'm not sure that I understand how to handle that. 
Any help in this matter would be greatly appreciated!!

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

    Try like

    SUMX(summarize(COEF_DATA, COEF_DATA[Run ID],"_mes"
    CALCULATE(MIN('TIME DATA'[Time])-MAX('TIME DATA'[Time]))),[_mes])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

      Thanks for the response, I will repost with a better synopsis and data.

       
       
       
       
       
       
       
       
       
       

       

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous ,

     

    Where is the time column in your sample data and do you have built a date column?

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.