Skip to main content

Power BI

Needs Votes

field of "duration" type

Vote (1100) 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 (180)
Daniel wu's profile image Profile Picture

aaea59c0 a5f3-4f87-b8ef-f5da4059a7fc 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

d1be4022 6419-4f85-87cf-9d4a137fa0e5 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

c8f4819e f9cb-48f0-8fd6-1ae0f68d44ac 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

76a13e5a bf8e-4ea3-bd67-9991ae99774b 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

ec0ec38b 262c-407d-9551-667f3e255de5 on 05 Jul 2020 23:36:53

RE: field of "duration" type

Please add this ASAP!

Daniel wu's profile image Profile Picture

6778f03a 1732-4c76-835f-80a8c4071544 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

de6b8671 b9a4-421a-bf1d-b56bd2fe0ce1 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

6bcb4505 84ec-4d9b-b3e6-3983c287d93f 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

a938fb6c dc93-4682-a577-af7ac2c5f0ec 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

f69c550d cdf3-4ab8-aee2-d3bbb2e5c012 on 05 Jul 2020 23:34:51

RE: field of "duration" type

3 years of request and nothing.