cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Sum HH:MM:SS field

I have a field which is the time of a call as a string format, it's derived from the Duration field which is in seconds. The DnNO field is the ID for the person making the calls. Now if I remove the other columns, the Calculated Column Time won't aggregate itself since it's a string format. I can't do a sum over it either. What's the best way to show the amount of minutes called in this case?

 

Example PBI Calls.JPG

4 REPLIES 4
vivran22 Established Member
Established Member

Re: Sum HH:MM:SS field

@MauriceMecowe 

 

Hi,

 

It is not very clear from your description on the output you need, you can convert the text duration into time and then create measures to show the total duration. You may also use the Duration column to calculate total duration.

 

I have created a sample pbix file here

 

If you could share the expetcted outcome, then it would help in suggesting a better way.

 

Rgds,

Vivek

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Sum HH:MM:SS field

Hi @vivran22 ,

 

Your solution is exactly what I need, but the only difference is that my Time field is a string and not a time/date type column. And I don't see an easy way to transfrom this from within SSAS. 

vivran22 Established Member
Established Member

Re: Sum HH:MM:SS field

@MauriceMecowe 

 

Have you tried transforming the column in Power Query(Right Click on the table > Edit Query) ?

Super User III
Super User III

Re: Sum HH:MM:SS field

There's also the option of summing the appropriate Duration fields and re-converting it to HH:MM:SS format for display. 

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors