Forum Discussion

dyrefors's avatar
dyrefors
New Member
8 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 t...
petrovnikitamai's avatar
petrovnikitamai
Icon for Resolver V rankResolver V
8 years ago

i'm not sure but try to use semicolon delimiter

rafaelmpsantos's avatar
rafaelmpsantos
Icon for Responsive Resident rankResponsive Resident
8 years ago

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
    8 years ago

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

     

    • rafaelmpsantos's avatar
      rafaelmpsantos
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      When you type "DATE(" they show you a grey popuplike in the image bellow, with the correct syntaxe. Show us this popup

      • rafaelmpsantos's avatar
        rafaelmpsantos
        Icon for Responsive Resident rankResponsive Resident
        8 years ago

        I think that for some reason, your computer List Separator was changed.

         

        To fix it... Go to Control Panel>Region>Click Additional Settings> and Change List Separator to comma., apply and ok...Close your pbi file and open again and it will be fixed.

         

        If this solve your problem mark as solution, and send me a feedback with your Like in this post.