Forum Discussion

sam_rea_02's avatar
sam_rea_02
Frequent Visitor
3 years ago
Solved

How to sum a time in power bi?

Hi All,   Need your help guys, below is the data i have. DATE Time Calls Answered AHT Sec 08/06/2023 8:00 1 0:04:01 08/06/2023 8:00 1 0:22:27 08/06/2023 9:00 1 0:14:15 0...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi sam_rea_02 ,

     

    Please try:

    First create a new column:

    Then apply the measure:

    Sum of AHT = TIME(HOUR(SUM('Table'[AHT Sec])/SUM('Table'[Calls Answered])),MINUTE(SUM('Table'[AHT Sec])/SUM('Table'[Calls Answered])),SECOND(SUM('Table'[AHT Sec])/SUM('Table'[Calls Answered])))

    Final output:

    Best Regards,

    Jianbo Li

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

  • sam_rea_02's avatar
    sam_rea_02
    3 years ago

    Thanks Jianbo for the help. It is a big help.

sam_rea_02's avatar
sam_rea_02
Frequent Visitor
3 years ago

Thanks Jianbo for the help. It is a big help.