Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hey All,
I am trying to represent the time it took to complete a task. My data is below. Trying to get the differene between 'Execution Time' and 'Conf. Time'. So in this case, I would want Power BI to return "02:17". Sometimes this value will be greater than "24:00". How can I have this data represented in Power BI? It is easy in Excel, but not so straight forward in BI.
Solved! Go to Solution.
You want Chelsie Eiden's Duration:
You want Chelsie Eiden's Duration:
Thanks! Will this account for times greater then 24 hrs? I.e will it return that it took 36 hours to accomplish the task?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 9 | |
| 8 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 24 | |
| 16 | |
| 15 | |
| 15 | |
| 9 |