Forum Discussion

Varela's avatar
Varela
Frequent Visitor
9 years ago
Solved

Round down stopped working

the dax below was working fine yesterday, today it is not anymore, don't know what happened   Md. Real Resolucao = VAR Duration = AVERAGE (Tickets2016[Tempo Real Resolucao - Segundos]) VAR Hours...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    You have substituted periods for commas in almost every VAR statement.

Varela's avatar
Varela
Frequent Visitor
9 years ago

the sintax '0' is incorrect. (DAX(VAR Duration = AVERAGE (Tickets2016[Primeira Resposta Duracao Segundos])VAR Hours = ROUNDDOWN ( Duration / 3600. 0 )VAR Minutes = ROUNDDOWN ( ( Duration - ( Hours * 3600 ) ) / 60. 0 )VAR Seconds = MOD ( Duration - ( Hours * 3600 ), 60 )VAR H = IF ( LEN ( Hours ) = 1. CONCATENATE ( "0", Hours ), CONCATENATE ( "", Hours ) )VAR M = IF ( LEN ( Minutes ) = 1. CONCATENATE ( "0", Minutes ), CONCATENATE ( "", Minutes ) )VAR S = INT(IF ( LEN ( Seconds ) = 1. CONCATENATE ( "0", Seconds ), CONCATENATE ( "", Seconds ) ))RETURN CONCATENATE ( H, CONCATENATE ( ":", CONCATENATE ( M, CONCATENATE ( ":", S ) ) ) ))).

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You have substituted periods for commas in almost every VAR statement.

  • Varela's avatar
    Varela
    Frequent Visitor
    9 years ago

    That's what happend, had to change my pc settings to make a software work, good call. thanks