Forum Discussion

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...

Anonymous
9 years ago
You have substituted periods for commas in almost every VAR statement.

Anonymous

Not applicable

9 years ago

Can you be more specific? In what way is it not working?

Varela
Frequent Visitor
9 years ago
it says there is sintax errors.
- Anonymous
  Not applicable
  9 years ago
  I'm not getting any error messages when I copy your formula into my test data. Works just fine. Are you sure you haven't accidentally deleted a comma or a parentheses somewhere when you tried to enter it? What exactly does the syntax error message say?
  - 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 ) ) ) ))).