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
Icon for Community Support rankCommunity Support
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.