I have a seconds column for the talktime, I would like to show average talktime for each catgory in the HH:MM:SS format.
Data in the tables
Would like below results
Thanks in advance
Go to Solution.
Hi @Daven ,
Would you please refer to the measure below:
VAR _Duration =
AVERAGEX ( 'Table', 'Table'[Talktime_InSeconds] )
VAR Hours =
INT ( _Duration / 3600 )
VAR Minutes =
INT ( MOD ( _Duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
ROUNDUP ( MOD ( MOD ( _Duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
Hours * 10000 + Minutes * 100 + Seconds
Then change the data type to custom and 0:00:00 :
For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERNkGZGrCQxIs3eBOT...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Please try this
Measure = FORMAT( CALCULATE(AVERAGE(Sheet13[Talktime_InHMS]),ALLEXCEPT(Sheet13,Sheet13[Team])),"HH:MM:SS")
Proud to be a Super User!
@Daven , Try like New column
time = time(0,0,[Talktime_InSeconds])
It works perfectly!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.