Forum Discussion

Shaik_amir's avatar
Shaik_amir
New Member
9 years ago

Problems with hour format greater than 24 hours

Hi there,   How to find average of time which is more then 24 hours in power Bi like 158 hours is average time taken by lab to complete one report of patient.   example this is below data from ex...
Need Help
Show and Tell
Tips and Tricks
fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

....  This is as close as I can get to what you are tryingn to do....

 

I have broke up your TEXT data by delimiter then recalculated a custom column to determine your duration in **DAYS**.  Days is required to conver to Duration (Not pictured);  I 'Change Type' in Power BI Query Editor to convert the newly calcualted column back into a Duration.  This changes your 53:22:40 example into 2.05:22:40 in Duration Formatting.

 

Now that I have a Duration formatted column, I can easily Average in Power BI.  The hard part (where i'm stuck) is converting the duration Average back into HH:MM:SS foramt??  My 2nd screen shot below is Average Hours, mabye someone can pick up it from here???

 

FOrrest

 

  • Shaik_amir's avatar
    Shaik_amir
    New Member
    9 years ago

    Thanks for your help pal.

     

    Really appreciate this but inspite of splitting the data cant we do the same with exicting format of time as 53:22:40  HH:MM:SS.

     

     

    Thanks alot