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.
Hello guys,
the next challenge for me is to calculate the DURATION_SOLUTION in minutes(integer).
In the current table i have a formule for DURATION_SOLUTION, which is ENDTIME - STARTTIME. in the following image is an example (see the red markered) that the CI_NAAM Clarity has a negative duration_solution.
This incident is at 02-01-2017 started en ended two days later at 04-01-2017. So basically i expected the total duration_solution in minutes 1476 minutes.
How can i fix this ? Thank you all.
Solved! Go to Solution.
Hi @Anonymous,
You can try to use below formula to calculate the date diff from date and time.
Calculate column:
TimeDiff(Minute) = var dayDiff = DATEDIFF(DATEVALUE([StartDate]),DATEVALUE([EndDate]),MINUTE) var hourDiff=LEFT([EndTime],2)- LEFT([StartTime],2) var minuteDiff= RIGHT([EndTime],2)-RIGHT([StartTime],2) return dayDiff + hourdiff *60 + minuteDiff
In my sample, startdate and enddate are text format, enddate and startdate are number type.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
You could use formula: DURATION_SOLUTION= datediff(STARTDATE,ENDDATE,Minute) + (ENDTIME - STARTTIME)
Hello @tringuyenmingh92,
Thanks for your response but unfortunatly this measure doesnt work. Check the underneath result.
Hi @Anonymous,
You can try to use below formula to calculate the date diff from date and time.
Calculate column:
TimeDiff(Minute) = var dayDiff = DATEDIFF(DATEVALUE([StartDate]),DATEVALUE([EndDate]),MINUTE) var hourDiff=LEFT([EndTime],2)- LEFT([StartTime],2) var minuteDiff= RIGHT([EndTime],2)-RIGHT([StartTime],2) return dayDiff + hourdiff *60 + minuteDiff
In my sample, startdate and enddate are text format, enddate and startdate are number type.
Regards,
Xiaoxin Sheng
Hi @Anonymous
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |