Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Problems with DAX MID functtion in new version?

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"
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago
        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.