Forum Discussion
rainwave
9 years agoNew Member
Chart Aggregated Durations
Hello Folks
I was wondering if anybody can help me out.
I am trying to chart time durations.
In my querie I have
HOURS
0:00:01:59
0:02:00:00
0:04:00:00
which would come out to 6:01 (6 hours and 1 minutes)
Trying to chart Hours with SUM but it does not add up.
Thanks All
Josh
1 Reply
- v-ljerr-msftMicrosoft Employee
Hi rainwave,
Currently, Duration data type is not supported in Power BI. Your 'HOURS' column with duration format is treated as Text in Power BI, so it cannot be SUMed.
Here is an idea about supporting Duration data type shared on Power BI Ideas. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:
Regards