Forum Discussion

ranis1227's avatar
ranis1227
Helper I
3 years ago
Solved

Time value for an Average Column

Hello,

 

I created a summarized table and  am trying to convert an average time value (Average Hour Time in this case) to a time format (HH:MM:SS). See Screenshot: 

 

 

So 12.11 for Medicine Emory A should convert to roughly 12:07. 

 

Any help will be greatly appreciated.    

  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi ranis1227 ,

     

    You can try this method:

     

    New a measure:

    Average_Time =

var _hours = ROUNDDOWN(SUM('Table'[Average Hour Time]), 0)

var _minutes = (SUM('Table'[Average Hour Time]) - _hours) * 60

var _seconds = (_minutes - ROUNDDOWN(_minutes, 0)) * 60

return

TIME(_hours, _minutes, _seconds)

     

     

    Need to change the type here:

     

    The result is:

     

     

    Hope this helps you. Here is my PBIX file.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies