Forum Discussion

joku's avatar
joku
Frequent Visitor
9 years ago

cumulative time

I'd like to import time (hours, mintues and seconds) into Power BI, but I get an error; Expression.Error: We couldn't parse the input provided as a Time value.

 

The times are in the following format 1:02:15 (1 hour, 2 miutes 15 seconds)

I do not wan't to interpret the times as times of the day, but rather as just time spent, and I would like to sume those times.

This does not seem to be an easy task in Power BI? Everything I try fails,...

 

 

2 Replies

  • joku's avatar
    joku
    Frequent Visitor
    9 years ago

    I'd like to import time (hours, mintues and seconds) into Power BI, but I get an error; Expression.Error: We couldn't parse the input provided as a Time value.

     

    The times are in the following format 1:02:15 (1 hour, 2 miutes 15 seconds)

    I do not wan't to interpret the times as times of the day, but rather as just time spent, and I would like to sume those times.

    This does not seem to be an easy task in Power BI? Everything I try fails,...

     

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi joku,

     

    The Duration data type is not supported in Power BI data mode currently. Here is a similar idea about support for "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