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

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

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!