Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Madmaxigail
Frequent Visitor

Time on Task

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

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

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

Microsoft Employee

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?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors