Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am relatively new to Power BI and need help with the following:
I have a dataset in Excel that shows me why a machine was malfunctioning. For each malfunction, I have the reason for malfunctioning ("Reason), a starting time ("Van"), and an ending time ("Tot"). Based on those times, I calculate the duration in Excel as "Tot" minus "Van". The duration is of data type "time" (hh:mm:ss). See also the screenshot below.
I would like to produce a visual that aggregates the total malfunction time for each "Reason" (as in a PivotTable in Excel). In other words, for above screenshot, the resulting table would need to show this:
However, when I try to do that with a table visual in Power BI, this is what I get as a result. Does anyone know how to resolve this?
Thanks in advance!
Solved! Go to Solution.
Hi, @NiekHacquebord
You need to create a measure to replace you original column field as below:
Measure_Duration = SUM('Table'[Duration])
Then change the format of measure as below:
Best Regards,
Community Support Team _ Eason
Hi, @NiekHacquebord
You need to create a measure to replace you original column field as below:
Measure_Duration = SUM('Table'[Duration])
Then change the format of measure as below:
Best Regards,
Community Support Team _ Eason
Thanks a lot for your solution, I managed to fix it with your help!
@NiekHacquebord You will need to convert those durations to seconds, add them and essentially convert them back more or less. Look at the links below, they should get you what you need.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |