Forum Discussion
DAX IF error: the syntax is incorrect
The answer to this must be really simple but I can't find it...
I have the following formula in Power Pivot,
=IF([Minstock]>0, 1, 0)where MinStock is a column in the same table of data type "Whole number",
but I get the error "The syntax for '1.' is incorrect", and I can't figure out why?
Could this have something to do with regional settings? In Excel formulas, I use semicolon instead of comma, and in my PowerPivot, the decimal numbers have a comma instead of a point.
I seemed to have solved it by changing the list separator in Windows Regional settings to semicolon, and then using the semicolon in the DAX formula.
=IF([MinStock] > 0; 1; 0)For future reference, I found the settings here:
Windows key, then type "region":
In the "Regional Format" window, click on "Additional date, time & regional settings"
Then "Change date, time or number formats"
There: "Additional settings"
There, change "List separator" to semicolon:
I then restarted Excel, not sure if that was necessary.
(To be complete, I also first changed the decimal and grouping separators to respectively point (.) and comma (,) but finally reverted them and it still works.)
