Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average Talktime in HH:MM:SS format

Hi,

 

I have a seconds column for the talktime, I would like to show average talktime for each catgory in the HH:MM:SS format.

 

Data in the tables 

Call_IDTeamTalktime_InSecondsTalktime_InHMS
1A50800:08:28
2A47500:07:55
3A30900:05:09
4B77900:12:59
5B27700:04:37

 

 

Would like below results 

TeamAverage Talktime
A0:07:11
B0:08:48

 

Thanks in advance 

 

Daven

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Would you please refer to the measure below:

     

    Measure =
VAR _Duration =
    AVERAGEX ( 'Table', 'Table'[Talktime_InSeconds] )
VAR Hours =
    INT ( _Duration / 3600 )
VAR Minutes =
    INT ( MOD ( _Duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
    ROUNDUP ( MOD ( MOD ( _Duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
RETURN
    Hours * 10000 + Minutes * 100 + Seconds

     

     

    Then change the data type to custom and 0:00:00 :

     

     

     

    For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERNkGZGrCQxIs3eBOTeC0gMBo5mFaWB5fG_0p1D_m6CYLQ?e=bCpouF

     

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

     

    Best Regards,

    Dedmon Dai

4 Replies