Time on Task

[Madmaxigail]

I have a problem.  I am trying to evaluate when all my vehicles are busy servicing customers.  I have reworked this data many times trying to get an answer and I can’t get to a final result. Here is a sample of relevant data, understanding that I have many more columns in my dataset.

Date	Call#	Time Started	Time Complete
January 1, 2022	000	10:28	11:28
January 1, 2022	001	10:45	10:55
January 1, 2022	006	11:00	11:35
January 1, 2022	008	11:02	11:30
January 1, 2022	014	11:46	12:05

It would be nice to see this information in a Gantt type view but knowing how much time each day I had 1 vehicle out at a time, 2 vehicles out at a time, 3 vehicles out at a time, etc. would be great.

I have been able to produce something really clunky in 15 minute increments using Excel but I think its only half the solution.  I would like to see if there’s a better way of doing this in Power BI.

Thanks in Advance

[ppm1]

You can use the technique shown in this video to do that. Create a time table with your 15 min increment, do not create a relationship to it, and write a DAX measure that counts the numbers of rows where the time started is below the time value in context and the time completed is after.

Create A Gantt Chart In Power BI With A Matrix Visual - YouTube

Pat

[Madmaxigail]

Thanks for the Gantt suggestion, I will try it.  Coming up with a total time value where I had 1 vehicle out, 2 vehicles out, etc. per day would be awesome.  Any suggestions on how to accomplish that?