Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
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.
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.
Have you tried transforming the column in Power Query(Right Click on the table > Edit Query) ?
There's also the option of summing the appropriate Duration fields and re-converting it to HH:MM:SS format for display.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |