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)
RE: field of "duration" type
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.
RE: field of "duration" type
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
RE: field of "duration" type
Need to make graph about duration time
RE: field of "duration" type
We need this to graphically represent times as well as having text durations.
RE: field of "duration" type
Can't operate Power BI in a call centre environment without durations!
RE: field of "duration" type
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
RE: field of "duration" type
Conveter (HH:mm) to Duration querying
excel information.
please help me.
RE: field of "duration" type
The Google analytics pack has problems as well as average session duration is a data type of duration
RE: field of "duration" type
For anywhere that operates a call center, being able to show duration is an absolute must!