Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Syntax Checker for Calculated Column

Dear PowerBI Community I encounter a strange issue since the September Update of PowerBI Desktop. I have the following calculated column: Project Status CRM = SWITCH ( [StatusCode], 1...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 



The syntax for '"Neu"' is incorrect. (DAX(SWITCH ( [StatusCode], 1. "Neu", 300800002. "Temporär freigegeben", 300800003. "Freigegeben", 717700000. "Finale Verrechnung", 100001. "Abgeschlossen", 717700001. "Storniert", 717700002. "Gesperrt", 4. "Blockiert", 300800000. "In Bearbeitung (Obsolet)", "Unbekannter Status"))).

For your code , please change "." to "," in some places.

(SWITCH ( [StatusCode], 1, "Neu", 300800002, "Temporär freigegeben", 300800003,"Freigegeben", 717700000, "Finale Verrechnung", 100001, "Abgeschlossen", 717700001, "Storniert", 717700002, "Gesperrt", 4. "Blockiert", 300800000, "In Bearbeitung (Obsolet)", "Unbekannter Status")))

BTW, you can check your DAX code in the site.

http://www.daxformatter.com/