The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |