Forum Discussion

rainwave's avatar
rainwave
New Member
9 years ago

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-msft's avatar
    v-ljerr-msft
    Microsoft 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