Chelsie 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...

ChelsieEidensDuration.pbix145 KB

Other

Time Intelligence

Totals

BeckiB

Frequent Visitor

2 years ago

Hi Greg (and others),

Thank you so much for sharing this! It's been an absolute life saver when it comes to displaying durations for various measures I'm reporting on. Although I appreciate it was 2019!

However, I'm having an issue with one of my measures.

They are input to PowerBI as hh:mm:ss and data type set as time; I'm then converting into seconds (when I update this, I'll do the conversion in SQL for ease).
I'm then converting BACK to hh:mm:ss using Chelsie's duration custom format. This has been successful for all but one measure where I have an average of 00:04:96.

HOWEVER:

Since I'm converting to seconds within PBI I'm creating a "Seconds" measure, which I then can't calculate the SUM of to put into yours/Chelsie's formula.

If I create the "Seconds" measure as a new column within the table, the conversion doesn't work.

This has not been an issue with the other duration I'm calculating, where all ":ss" values are <60. Any ideas on where my issue is?

Many thanks!

PranamG

New Member

2 years ago

For Average Wrap Duration, you need to divide Duration by Total Rows using CountRows function (COUNTROWS[Transferred Calls]) and then convert the result in terms of Hours, Minutes and Seconds. Hope this helps!