Forum Discussion
Calculate time for two columns and its average
Is there anyone who can aid me in computing the discrepancy between these two columns as well as determining their average, with the aim of presenting it graphically for each team?
2 Replies
- amitchandak
Super User
New column =
var _sec = datediff([Message Read Time], [End Click Time] , second)
return
time(0,0,_sec )
or a measure like
New measure =
var _sec = Sumx(Table, datediff([Message Read Time], [End Click Time] , second) )
return
time(0,0,_sec )
Also, check
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 Hi, Thank you I already have the seconds
but how to calculate the average?
