DAX Help - Time Duration Sum when the date switches

[Anonymous]

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!!

[v-yuta-msft]

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

[Greg_Deckler]

Where is the Date in your data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Sample data as text.

[amitchandak]

@Anonymous ,

Try like

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

[Anonymous]

@amitchandak 

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