Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all! My previous post somehow got lost in the abyss of the interwebs, so I'm making it again.
I have a table which records device usage in my business. It records the device name, the time in, and time out.
time out | time in | device name |
31/3/17 13:28 | 31/3/17 13:39 | 0001 |
31/3/17 13:31 | 31/3/17 14:38 | 0002 |
31/3/17 13:49 | 31/3/17 14:25 | 0001 |
The long and short of our goal is this: to be able to calculate how many hours each day the devices are being used (not each individual device, I don't think, but all devices together), and to be able to isolate which times of day in particular they are being under-used.
A device has a 12 hour period each day where it can be used, and there are 6 devices, so in total we're comparing time the devices checked out to 72 hours (maybe with some kind of pie chart or something showing what percent of 72 hours the sum of use-time is).
I was also envisioning some sort of graph that looks like this, to illustrate device checkout times:
Anything powerBI can do to make these tasks easy for me?
I think you can create a calculated column to get the during seconds of each record. And then aggregate the duration by day to calculate the utilization percentage.
duration = DATEDIFF('Table'[time out],'Table'[time in],SECOND)
As to the gantt chart, AFAIK, there's no offical visuals that support time level. The gantt visual in @dkay84_PowerBI link is for date level. If you still prefer that kind of visual, you can submit your idea at Power BI Ideas and vote it up.
Hi all!
I have a table which records device usage in my business. It records the device name, the time in, and time out.
time out | time in | device name |
31/3/17 13:28 | 31/3/17 13:39 | 0001 |
31/3/17 13:31 | 31/3/17 14:38 | 0002 |
31/3/17 13:49 | 31/3/17 14:25 | 0001 |
The long and short of our goal is this: to be able to calculate how many hours each day the devices are being used (not each individual device, I don't think, but all devices together), and to be able to isolate which times of day in particular they are being under-used.
A device has a 12 hour period each day where it can be used, and there are 6 devices, so in total we're comparing time the devices checked out to 72 hours (maybe with some kind of pie chart or something showing what percent of 72 hours the sum of use-time is).
I was also envisioning some sort of graph that looks like this, to illustrate device checkout times:
Anything powerBI can do to make these tasks easy for me?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |