How can we improve Power BI?

field of "duration" type

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

606 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Daniel wu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    101 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • João Carlos commented  ·   ·  Flag as inappropriate

        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.

      • Chris99 commented  ·   ·  Flag as inappropriate

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

      • Kris Gomez commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

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

      • Marco commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

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

      • Chris99 commented  ·   ·  Flag as inappropriate

        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?

      • Anonymous commented  ·   ·  Flag as inappropriate

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

      • Anonymous commented  ·   ·  Flag as inappropriate

        I'm just getting into Power BI and I ran into this issue. I already have the duration calculated in my Excel data source, so all I need the report to show is the value...in hh:mm. How on earth was this not done during the original build?
        What use is a business intelligence tool that can't display time in hh:mm?

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is basic functionality. And its been waiting 3+years for implementation.

        Allow us at least similar make-up option as in Excel - treat the time as integer (for calculating purposes) and apply the time format as some kind of mask in next step.

      • Javi Gonzalez commented  ·   ·  Flag as inappropriate

        Power Query doesn't calculate the duration correctly and the best solution in DAX is to create a "time text" formula, so you cannot sum or do other maths with it. With several duration values in seconds, that usually go over 24hrs (so Time is not an option), this is a must.

      • Troy Prill commented  ·   ·  Flag as inappropriate

        When is this going to happen, Microsoft? You've added it to the Query Editor but not the report field?

      ← Previous 1 3 4 5 6

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.