Forum Discussion
Aggregating Duration/Time
How can I aggregate the total hours for each ticket priority? I tried to convert the time to decimal but when I tried to get the average, its not aggregating. please help
Hi Anonymous,
Please create the measure using the following formula.
Measure-format = FORMAT(AVERAGE(Table2[total_time]),"HH:MM:SS")
Best Regards,
Angelia
Hi v-huizhn-msft Angelia,
Thank you for your response but how can I get the average by grouping them by priority?
Thanks!