Forum Discussion

dyrefors's avatar
dyrefors
New Member
7 years ago

Can't input calculated column formulas

Hello!

 

After a recent update of Power BI desktop I can't input any formulas. It looks like the application tries to change the commas (,) into points (.) in the argument list.

 

I guess this might have something to do with the locale settings on my computer but I don't understand why.

 

Please help, thanks!

11 Replies

    • rafaelmpsantos's avatar
      rafaelmpsantos
      Responsive Resident

      It is caused by the Config of Region in you windows. If The decimal number is set to use coma you cannot use it to in you dax formula, you need to use semicolon.

      • dyrefors's avatar
        dyrefors
        New Member

        Thanks for the reply but I get the same kind of problem with semi colon as well.

         

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi dyrefors,

    Based on my test, it could work on my side, dose any problem with your format?

    Could you please copy my below formula to have a test:

    Column = DATE(2018, 1, 1)

     

    Regards,

    Daniel He