field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?
Daniel wu
shared this idea
133 comments
-
Anonymous
commented
I've just tried to upload information into Power BI the hours are in the [h]:mm:ss however it cannot cope with this format and anyone working over 24 hours are now showing incorrectly.
Can you please add this.
-
Robert A.
commented
Please add this as an option for Time formatting in Power BI - [h]:mm:ss
I should be able to use this just as I do in Excel.
-
Jorgemenas
commented
This is a really essential feature for the Google Analytics pack. I hope they do it soon!
-
Ben
commented
Power BI are missing a trick by not having this in! As others say it's really essential for contact centres and Power BI is such a great way of displaying data to teams like this their product dev/sales teams really need to get it sorted.
-
Mauro Giusti commented
Same issue, see here - all you need to test this is a SQL query that returns a TIME type.
https://community.powerbi.com/t5/Desktop/Can-t-use-SQL-TIME-as-Duration/m-p/97180 -
Vino
commented
Need to make graph about duration time
-
Lex
commented
Can't operate Power BI in a call centre environment without durations!
-
Anonymous
commented
We need this to graphically represent times as well as having text durations.
-
Bob Smith
commented
Essential Call Centre and Telesales metric. We cannot roll out Power BI in our org without this
-
Steven Wheeler
commented
Power Query has a Duration data type and dedicated functions to analyse durations, but in the Data View for Reports it gets converted to a decimal part of a day - e.g. 20 seconds shows as 0.00:00:20 in Power Query but as 0.000231481 in Reports. And to manipulate it needs convoluted DAX - e.g. http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
-
Anonymous
commented
Conveter (HH:mm) to Duration querying
excel information.
please help me. -
Blair
commented
The Google analytics pack has problems as well as average session duration is a data type of duration
-
john.brennan
commented
For anywhere that operates a call center, being able to show duration is an absolute must!