Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])))
)
@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.
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 ,
Try like
SUMX(summarize(COEF_DATA, COEF_DATA[Run ID],"_mes"
CALCULATE(MIN('TIME DATA'[Time])-MAX('TIME DATA'[Time]))),[_mes])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |