Forum Discussion
Resolver IISum 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?
4 Replies
- vivran22
Community Champion
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.
MauriceMecoweHi 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
Have you tried transforming the column in Power Query(Right Click on the table > Edit Query) ?
