DAX syntax error (Beginner)

[Anonymous]

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 help would be appreciated.

[Greg_Deckler]

That is the correct DAX syntax, I recreated it exactly. Are you entering this in the data model or in Power Query? Because Power Query uses "M" language, not DAX. The error you are showing looks like it is coming from Power Query, not the data model.

In "M", it would be:

Cond1=if [Förs. YTD] > [Tot. Förs. föreg. år] then 1 else 0

[Anonymous]

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]

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]

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]

@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