Forum Discussion
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])))
)
4 Replies
Anonymous ,
Try like
SUMX(summarize(COEF_DATA, COEF_DATA[Run ID],"_mes" CALCULATE(MIN('TIME DATA'[Time])-MAX('TIME DATA'[Time]))),[_mes])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.
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.
