Power BI

Needs Votes

field of "duration" type

Vote (1100)

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)

Comments (180)

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

fbe20f8a 3060-41af-a788-68c1f02018b4 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...

bc5ac516 f497-4a8e-830c-4a0424675e1a on 05 Jul 2020 23:32:38

RE: field of "duration" type

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?

08e573ab 6a54-4281-b0da-210ccea6e311 on 05 Jul 2020 23:31:59

RE: field of "duration" type

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.

7f7473fa 227d-4fec-a972-660707d53d0b on 05 Jul 2020 23:31:58

RE: field of "duration" type

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.