Show average time per month

[Itzarthi]

Hey Guys,

I'm trying to get the average session duration per month. Now it shows me the following:

Instead of the following and how can i get this view?

Month	Avg. session duration
Januari	00:05:13

I have not the option to sum this avg session duration:

[amitchandak · Accepted solution]

@Itzarthi , refer if these can help

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[Itzarthi]

@amitchandak thank you for the links. But these are for the totals and I don't understand how to do sum individual rows.

[Itzarthi]

I tried the DAX formula, but now it shows everywhere the total and not the seperate avg times.

[v-kelly-msft]

Hi @Itzarthi ,

Can you upload your .pbix file to onedrive business and share the link with us?

As for the "the seperate avg times",what do you mean?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!