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 =
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
    9 years ago

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

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Varela's avatar
      Varela
      Frequent Visitor

      it says there is sintax errors.

      • Anonymous's avatar
        Anonymous
        Not applicable

        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?