Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I added a custom column to convert seconds to hrs and mins and then another column to round this to nearest half hour. How do I create a column or measure that will give me the total time in hours and mins please, since its a time value?
Hi @rosscortb ,
Refer to this blog:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@V-lianl-msft Hello, Thanks for reply. I added the Dax formula to a new column and it worked. However, it comes out as Text, therefore you can't add it to get total hours and mins, any ideas? Thanks Ross
Hi @rosscortb ,
Refer to this thread:
https://community.powerbi.com/t5/Desktop/Seconds-to-Hours-Minutes-sum/m-p/888051
This is the way to calculate the total.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@rosscortb , Try like
time(hour(round(hour([time]+minute([time])/60,second([time])/3600),0)),0,0)
You can use roundup or rounddown in place of round
sorry, is this done in power query?
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |