Skip to main content

Power BI

Under Review

field of "duration" type

Vote (1563) Share
Daniel wu's profile image

Daniel wu on 12 Jul 2015 01:13:50

is it possible to add support for "duration" data type in the report view as in Power Query?

Comments (211)
Daniel wu's profile image Profile Picture

David Gómez on 05 Jul 2020 23:39:38

RE: field of "duration" type

Please... Ir is neccesary. I need it to work with timing data in mm:ss.00 format

Daniel wu's profile image Profile Picture

João Carlos on 05 Jul 2020 23:37:57

RE: field of "duration" type

I need to include a "duration" field in the chart to evaluate the duration of an event over time. I need it for "yesterday". Pls.

Daniel wu's profile image Profile Picture

Chris99 on 05 Jul 2020 23:37:48

RE: field of "duration" type

C'mon Microsoft. How about an update on this as a Christmas present? It is is pretty fundamental reporting requirement.

Daniel wu's profile image Profile Picture

Kris Gomez on 05 Jul 2020 23:37:17

RE: field of "duration" type

I agree with all regarding this field. I currently have a custom column showing duration between CreatedDate and ApprovedDate (both are datetime columns), but now would like to aggregate the duration column to show average duration and cannot.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:37:11

RE: field of "duration" type

Anonymous commented · December 5, 2018 3:40 AM · Flag as inappropriate
need Duration calculation on Power BI

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:53

RE: field of "duration" type

Please add this ASAP!

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:36

RE: field of "duration" type

need Duration calculation on Power BI

Daniel wu's profile image Profile Picture

Marco on 05 Jul 2020 23:36:33

RE: field of "duration" type

In my case, I needed to report time spent on site, so just formatting as text worked to give a visual representation of session duration. This will not work for operations though.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:00

RE: field of "duration" type

Please update Power BI to include Duration as a data type in the Date/Time category. I can use Power Query to convert individual start and stop times to calculate a duration, but the column can't be manipulated in Power BI to allow calculations such as the total duration from several instances so that it appears in a way that is easy to understand. Right now I've got a report that says things like "total training time = 46209 minutes" and it just isn't intuitive for my readers.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:56

RE: field of "duration" type

Hi, please add the function of dutation calculation within the tool ([h]:mm and be able to show the times within the reports accordingly! many thanks...