Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

DAX syntax error (Beginner)

Hello, the following DAX code renders a syntax error; Cond1=IF('Total Sales Norden Details'[Förs. YTD]>'Total Sales Norden Details'[Tot. Förs. föreg. år],1,0)   The syntax error is:   Any...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello and thank you for your help. I am entering it in the data model. Can it have something to do with the special characters in the column names?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I thought of that too, but it worked perfectly for me. The only thing I didn't replicate exactly was the table name, mine was called "Table4". Unless it is a difference between the language versions. What gets me is that red x, timestamp and weird "Query(1, 32)", I don't typically see that, can you post a larger screen shot that shows the context? Generally, when I mess up a DAX equation, I see something like:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    My mistake, I try to create the DAX in DAX studio and when I try to run it, that is when I get that error message.

     

    And if I put in the same code in BI Desktop to create a measure,  I get this error message;

     

    Sorry for the confusion...

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      Anonymous

       

      If you want to create a calculated column in Power BI Desktop.

      Please try to replace ; with ,

      Or replace , with ;

      They should be consistent.

       

       

      Best Regards,

      Herbert