Problems with DAX MID functtion in new version?

[Anonymous]

Hello everybody,

Am I the only one who is experiencing this issue:

Suddenly the MID functtion seems not to work anymore...see examples below.

Can anyone help or is anyone facing the same issue?

thanks and br

christoph

modelcalc =

MID (

t_plc03_models_total_live[mod],

6,

10

)

Error: The syntax for '10' is incorrect. (DAX(MID ( t_plc03_models_total_live[mod], SEARCH ( t_plc03_models_total_live[Modeltype], t_plc03_models_total_live[mod] ) + 5. 10))).

ExampleString: "Totalsnaiv"

[Anonymous]

Something isn't working at all:

I also get an error with this simple formula:

STG_Name =
IF ( STG[STG_ID] = 1, 1, 2 )

The syntax for '1.' is incorrect. (DAX(IF(STG[STG_ID] = 1. 1. 2))).

I also tried with semicolons. Didn't change anything.

thanks

[v-piga-msft]

Hi @Anonymous ,

By my tests with the latest version of Power BI Desktop (2.70.5494.701 64-bit (June 2019), I cannot reproduce your scenario.

Please check if you have installed the latest version of Power BI Desktop.

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry

[Anonymous · Accepted solution]

Found the issue: I opened a pbix file (created in German OS environment) in a not German OS environment. Once opened again in German environment, it worked again.