Forum Discussion
Helper IShow average time per month
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:
Itzarthi , refer if these can help
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
4 Replies
- amitchandak
Super User
Itzarthi , refer if these can help
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
Itzarthiamitchandak 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.