Average time in Second

[Anonymous]

Hi Experts

how would you work our the average time used. from the date below

Duration Second
213
176
143
134
814
404
379
686
405

[Tahreem24]

@Anonymous Please share the expected output also to better understand your query.

[Anonymous]

Hang fire - whlist i get a larger dataset  and expected result..

[v-kkf-msft]

Hi @Anonymous ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[amitchandak · Accepted solution]

@Anonymous , What is the issue

a New measure =

Average(Table[Duration Second])

refer if needed

Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389