Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'm new with Power BI and I want to be able to calculate Total timings per column
Could you please help?
Thank you
Solved! Go to Solution.
thank you for coming back to me.
Unfortunately, the link you provided doesn't resolve my issue.
However, I realised that the solution to this issue is to not use that format for data representing duration. Instead I converted those to decimal 60min = 1.0, 30mins= 0.5 and so on. This way I can get totals.
thank you
See if this helps:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279
thank you for coming back to me.
Unfortunately, the link you provided doesn't resolve my issue.
However, I realised that the solution to this issue is to not use that format for data representing duration. Instead I converted those to decimal 60min = 1.0, 30mins= 0.5 and so on. This way I can get totals.
thank you
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |