Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Token RightParen expected in a if then else function

i have have an "token rightparen expected" when writing this function to create a custom column and i don't know why. 

Can you please help me resolve it ?

 

the function :   if ( [#"Meta Statut (Incident)"] <> "Terminé" , ([Date de fin du mois]-[Enregistré le]), 0)

 

  • The M language has a different syntax from DAX

     if [#"Meta Statut (Incident)"] <> "Terminé" then ([Date de fin du mois]-[Enregistré le]) else 0

2 Replies

  • The M language has a different syntax from DAX

     if [#"Meta Statut (Incident)"] <> "Terminé" then ([Date de fin du mois]-[Enregistré le]) else 0

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you, it works