Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

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

Hitesh Kotecha on 16 Apr 2021 13:49:46

RE: field of "duration" type

I’m currently having to create (in Power Query) about 10 duration fields that’s first converted to seconds with type as an integer. Then doing some calculations in DAX to get the averages, max, min, differences, standard deviations etc. Then finally doing some complex conversions back to time.

Having duration type in DAX would avoid having the extra steps

Daniel wu's profile image Profile Picture

Jason Farrall on 01 Apr 2021 13:33:09

RE: field of "duration" type

An Absolute must!

Daniel wu's profile image Profile Picture

Jordan Metcalf on 27 Mar 2021 09:48:57

RE: field of "duration" type

Still not done? Christ come on!

Daniel wu's profile image Profile Picture

Q HARR on 23 Feb 2021 15:04:18

RE: field of "duration" type

How many years on? Where is this basic essential feature?

Daniel wu's profile image Profile Picture

Lorant Görgey on 18 Feb 2021 15:18:48

RE: field of "duration" type

1162 vote and nothing happens?

Daniel wu's profile image Profile Picture

BI Executiva on 17 Dec 2020 12:13:36

RE: field of "duration" type

So, what's the purpose to have duration data type in Power Query and not in Report View Mode? Please add duration data type in Report Mode or then remove duration data type from Power Query, since it's useless the way it's now, and won't create any expectation that it will work in report view mode.

Daniel wu's profile image Profile Picture

Kurt A. Hinds on 27 Nov 2020 18:12:24

RE: field of "duration" type

5 years and Duration is still seen as text....?

Daniel wu's profile image Profile Picture

Rodrigo Ribeiro on 18 Nov 2020 18:04:51

RE: field of "duration" type

For the love of the god.
Please add.

Daniel wu's profile image Profile Picture

Corrado Anghinoni on 09 Nov 2020 12:32:25

RE: field of "duration" type

Please add

Daniel wu's profile image Profile Picture

Edu Surveys on 31 Aug 2020 20:55:56

RE: field of "duration" type

I'm able to assign "duration" as a data type in Power Query, but then it totally gets messed up when I apply my query in the desktop app. What's going on? Is this supported yet?