Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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