Forum Discussion
Calculate Duration Across Multiple Dates and Items
Hello - Sorry if this has been asked before: I have a table that includes the date, vehicle, and time that it received a response. I've created a table that displays the vehicle, date, and start...
davehus
Memorable Member
Memorable MemberHi rsimpson318, replace the Sum(duration) with your Duration measure.
Did I help you today? Please accept my solution and hit the Kudos button.
It didn't give an error this time, but it still calculated the duration as the first date for the vehicle and the last day instead of the sum for the difference of each day. So in the table above, it's calculating the duration for vehicle 11603 as the difference between 08/01/22 06:16:56 AM and 8/26/22 08:07:46 AM instead of adding up all the values.