Forum Discussion
Event Duration Analysis
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...
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.