cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 2
Highlighted
Frequent Visitor

entering 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,...

 

 

Highlighted
Microsoft
Microsoft

Re: cumulative time

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. Smiley Happy 

 

Regards

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors