Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

field of "duration" type

is it possible to add support for "duration" data type in the report view as in Power Query?
Status: Under Review
Comments
JOutlaw
New Member
For anywhere that operates a call center, being able to show duration is an absolute must!
blair3
New Member
The Google analytics pack has problems as well as average session duration is a data type of duration
cleiton1
New Member
Conveter (HH:mm) to Duration querying excel information. please help me.
tastaiso
New Member
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
derek_border1
New Member
We need this to graphically represent times as well as having text durations.
lexberju
New Member
Can't operate Power BI in a call centre environment without durations!
vino_mahavira
Regular Visitor
Need to make graph about duration time
Maurgi
New Member
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
BPOPE
Frequent Visitor
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.
jorge-mena_saut
New Member
This is a really essential feature for the Google Analytics pack. I hope they do it soon!