Skip to main content
Microsoft Idea

    Power BI

    Under Review

    field of "duration" type

    Vote (1543) 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 (208)
    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...

    Daniel wu's profile image Profile Picture

    Fabio Coatis on 05 Jul 2020 23:34:51

    RE: field of "duration" type

    3 years of request and nothing.

    Daniel wu's profile image Profile Picture

    Chris99 on 05 Jul 2020 23:34:02

    RE: field of "duration" type

    is there any news on this Microsoft? I fail to see how so many years down the line this still hasn't been implemented.

    How can copy and paste features take preference over a fundamental reporting data type?

    Daniel wu's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:32:43

    RE: field of "duration" type

    Hi, i would appriciate to have the time calculation ([h]:mm) function within the Tool and be able to show the times within the reports accordingly! many thanks...