How to sum a time in power bi?

[sam_rea_02]

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
08/06/2023	9:30	1	0:15:25
08/06/2023	12:00	1	0:02:27
08/06/2023	12:30	1	0:02:03

when i put it on pivot table here is the output for the  Sum of AHT

to get the AHT= AHT Sec/Calls Answered. I need to get the correct sum when putting it on power bi. I am struggling to resolve this computation on power bi.  Hope you can help

[v-jianboli-msft · Accepted solution]

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 · Accepted solution]

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

[v-jianboli-msft · Accepted solution]

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]

I need an output same as the pivot table when I create a matrix.