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

    Scott Allen on 05 Jul 2020 23:53:03

    RE: field of "duration" type

    For all the work put into Time Intelligence functions, the fact that this is missing is unsettling.

    Daniel wu's profile image Profile Picture

    Sean on 05 Jul 2020 23:52:05

    RE: field of "duration" type

    please consider the duration type in a future update.

    Daniel wu's profile image Profile Picture

    David on 05 Jul 2020 23:51:48

    RE: field of "duration" type

    Would be an amazing addition to graph based on duration in minutes/ seconds for tracking performance metrics. Would greatly appreciate it!

    Daniel wu's profile image Profile Picture

    BW on 05 Jul 2020 23:51:11

    RE: field of "duration" type

    Would like better duration / time period calculations periods please. Would also like to be able to easily graph different times based on date.

    Daniel wu's profile image Profile Picture

    matabiau on 05 Jul 2020 23:49:57

    RE: field of "duration" type

    MS, please consider the duration type in a future update

    Daniel wu's profile image Profile Picture

    kapil on 05 Jul 2020 23:49:00

    RE: field of "duration" type

    Time formatted filed should be used with Sum, Avg function its common use of every one. Please also provide dynamic nature with sum, summarize function from Slicers.
    Regards
    Kapil

    Daniel wu's profile image Profile Picture

    Dixit Sharma on 05 Jul 2020 23:47:20

    RE: field of "duration" type

    Hello Team ,

    Our organization have more than 200 power bi users had an review from almost all of them are looking for Duration Data Type, in a lot of scenarios we wish to see the average of time and other calculations which is very important during Analysis of the Services we work upon.
    It would be way more beneficial if Power Bi has the capability to do that like in Excel .

    Thanks
    Dixit

    Daniel wu's profile image Profile Picture

    k on 05 Jul 2020 23:46:32

    RE: field of "duration" type

    This is a must have!

    Daniel wu's profile image Profile Picture

    Mark on 05 Jul 2020 23:46:01

    RE: field of "duration" type

    Very needed as time duration's are essential in any planning type analysis.

    Daniel wu's profile image Profile Picture

    Guy on 05 Jul 2020 23:45:10

    RE: field of "duration" type

    Honestly, this is a much needed feature. I shouldn't have to mess around in excel with all it's extra steps to convert time (which is recorded as a decimal in my company) into a duration. As it stands .5 (which for us is a half hour, or 30 minutes) equates to a half day or 12:00:00 hours.

    Please give us some options here.