Forum Discussion
call center duration
llyons - I have some articles on this that I think you will find helpful:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Hi, llyons
Based on your desciprion, I created data to reproduce your scenario.The pbix file is attached in the end.
Table:
You may create a custom column as below in 'Query Editor'.
= Table.AddColumn(#"Changed Type", "Custom", each let dur=[End]-[Start] in #time(Duration.Hours(dur),Duration.Minutes(dur),Duration.Seconds(dur)))In Power BI Desktop, you may create a calculated column as below to calculate total seconds.
TotalSeconds = HOUR([Custom])*3600+MINUTE([Custom])*60+SECOND([Custom])Finally you may format the column as below.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I also have a similar issue. I have a column of seconds. I pull that and others into a Matrix visualization and it allows me to aggregate or average and thay all appear in their respective columns and they filter just fine. Trouble is, I would like to show the data in the columns as hh:nn:ss. I can add measures etc. but when I pull the data into the Matrix, it will not allow an average, only a First etc. Anyone got any thoughts?
Thanks.
CW