Formato hh:mm:ss

[rey4125]

Buenos Dias.

Estoy haciendo unos graficos en power Bi pero no me ha sido posible representar un promedio de un dato en formato hh:mm:ss

[Baskar · Accepted solution]

Cool my dear friend, Try this one

Age(HH:MM:SS) :=

VAR Duration = Measure in Seconds 
VAR Hours =
ROUNDDOWN ( Duration /3600 , 0 )
VAR Minutes =
ROUNDDOWN ( ( Duration - ( Hours *3600 ) )/60, 0 )
VAR Seconds =
ROUND(MOD ( Duration - ( Hours *3600 ),60 ),0)
VAR H =
IF ( LEN ( Hours ) = 1,
CONCATENATE ( "0", Hours ),
CONCATENATE ( "", Hours )
)
VAR M =
IF (
LEN ( Minutes ) = 1,
CONCATENATE ( "0", Minutes ),
CONCATENATE ( "", Minutes )
)
VAR S =
IF (
LEN ( Seconds ) = 1,
CONCATENATE ( "0", Seconds ),
CONCATENATE ( "", Seconds )
)

RETURN
CONCATENATE (
H,
CONCATENATE ( "h : ", CONCATENATE ( M, CONCATENATE ( "m : ", CONCATENATE(S,"s") ) ) )
)

[v-shex-msft · Accepted solution]

Hi @rey4125,

In my opinion, you can convert the time field to total second, calculated average of the total second, then format these data to time.

Sample:

Total Second= Hour(Table[Date])*3600 + Minute(Table[Date])*60+ Second(Table[Date])


AverageTime = 
var temp=INT(AVERAGE([Total Second]))
var h=INT(DIVIDE(temp,3600))
var m=INT(DIVIDE(temp-h*3600,60))
var s=temp-h*3600-m*60
return
TIME(h,m,s)

Regards,

Xiaoxin Sheng

[Baskar · Accepted solution]

Cool my dear friend, Try this one

Age(HH:MM:SS) :=

VAR Duration = Measure in Seconds 
VAR Hours =
ROUNDDOWN ( Duration /3600 , 0 )
VAR Minutes =
ROUNDDOWN ( ( Duration - ( Hours *3600 ) )/60, 0 )
VAR Seconds =
ROUND(MOD ( Duration - ( Hours *3600 ),60 ),0)
VAR H =
IF ( LEN ( Hours ) = 1,
CONCATENATE ( "0", Hours ),
CONCATENATE ( "", Hours )
)
VAR M =
IF (
LEN ( Minutes ) = 1,
CONCATENATE ( "0", Minutes ),
CONCATENATE ( "", Minutes )
)
VAR S =
IF (
LEN ( Seconds ) = 1,
CONCATENATE ( "0", Seconds ),
CONCATENATE ( "", Seconds )
)

RETURN
CONCATENATE (
H,
CONCATENATE ( "h : ", CONCATENATE ( M, CONCATENATE ( "m : ", CONCATENATE(S,"s") ) ) )
)