Forum Discussion
Syntax Checker for Calculated Column
Hi Anonymous ,
Does your regional settings have comma as decimal separator? When working with numbers and having the decimals mark as comma I have encountered that if that is matching with the comma of the parameters of functions I need to add the ,0 as part of my syntax for numbers.
Believe that this is what is happening here. Using 300800003, or 300800003,0 is the same for the syntax not really sure why is happening currently with the September version but could be this.
Regards,
MFelix
OMG
It is working when I change the code as follows:
How does this make sense?
Community ChampionAnonymous
That's weird...
Maybe some of the support people can help v-lid-msft , v-lili6-msft , v-xuding-msft
or some of the super users Greg_Deckler , Zubair_Muhammad , MFelix
- MFelix
Super User
Hi Anonymous ,
Does your regional settings have comma as decimal separator? When working with numbers and having the decimals mark as comma I have encountered that if that is matching with the comma of the parameters of functions I need to add the ,0 as part of my syntax for numbers.
Believe that this is what is happening here. Using 300800003, or 300800003,0 is the same for the syntax not really sure why is happening currently with the September version but could be this.
Regards,
MFelix
Thanks MFelix
That's the explanation (altough the parameter [StatusCode] is formatted as whole number - but I guess that doesn't matter for the syntax...). I changed the Model language from German (Germany) to English (United States) and my formulas are working again without decimal character.
I have a new client and therefore a new installation of PowerBI desktop. Was most probably more related to that than to the September release.
Best,
Phil