Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear PowerBI Community
I encounter a strange issue since the September Update of PowerBI Desktop.
I have the following calculated column:
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
OMG
It is working when I change the code as follows:
@Anonymous
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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks 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
Hi @Anonymous
The code the error message shows has dots instead of the necessary commas after the numbers. Could that be the problem? And it complains about "Neu", which is what comes after the first dot.
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"))).
Thanks AIB for your fast reply!
Good hint and observation! But as you see in my code I use commas...
I tried typing them again but still the same.
Could this be related to a Locale that is set in the options?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |