Forum Discussion
Time not shown properly
Hi Anonymous
I suggest to use measure rather than calculated column to get the result. Since you want to calculate the average delay, get the average delay in seconds first, then change the format. Here is the PBIX file.
Average Delay = VAR averageDelay = ROUNDUP ( AVERAGE ( Sheet1[delay] ), 0 ) VAR Hours = INT ( averageDelay / 3600 ) VAR Minutes = INT ( ( averageDelay - Hours * 3600 ) / 60 ) VAR Seconds = averageDelay - Hours * 3600 - Minutes * 60 RETURN Hours * 100 + MinutesKindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
My purpose is to get the time value that would actually round up to the next hour at 60 minutes properly.
Community SupportHi Anonymous
I suggest to use measure rather than calculated column to get the result. Since you want to calculate the average delay, get the average delay in seconds first, then change the format. Here is the PBIX file.
Average Delay =
VAR averageDelay =
ROUNDUP ( AVERAGE ( Sheet1[delay] ), 0 )
VAR Hours =
INT ( averageDelay / 3600 )
VAR Minutes =
INT ( ( averageDelay - Hours * 3600 ) / 60 )
VAR Seconds = averageDelay - Hours * 3600 - Minutes * 60
RETURN
Hours * 100 + MinutesKindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.