Greg_Deckler
Community Champion
Community ChampionChelsie Eiden's Duration
Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...
Hey All, Anyone knows why some of the data shows over a minute? 00:00:79 instead of 00:01:19?
My dax is a little bit modified. I needed the average duration on a monthly basis so I had a months as my X axis. ASADuration was no longer summed because I had another field convert my time column to seconds already.
SpeedOfAnswerDuration =
AVERAGEX(
'call',
VAR ASADuration = 'call'[SpeedOfAnswerCol]
VAR Hours = INT ( ASADuration / 3600)
VAR Minutes = INT ( MOD( ASADuration - ( Hours * 3600 ),3600)/60)
VAR Seconds = ROUNDUP(MOD (MOD( ASADuration - ( Hours * 3600),3600),60),0)
RETURN
Hours * 10000 + Minutes * 100 + Seconds
)
Greg_DecklerCommunity Champion
Community ChampionKristoff15 You need to compute the AVERAGE of 'call'[SpeedOfAnswerCol] and THEN convert it to duration.
Simple yet effective solution! Thanks Greg!