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.
amitchandak Hi buddy,
I am sending the file, please note that the source of the pbix is the following excel and you need to change it in the power query settings(just change the source). Once u open the pbix you will see how the total average is displayed. In this case, it shows 00:84 minutes, when it should be over an hour.
You will find the file here:
https://easyupload.io/m/regwqm
- amitchandak
Super User
Anonymous , I added few measures in the file attached after signature; check if those can help
amitchandak It still does not make sense, as you can see the average time is still not displayed correctly.
