Forum Discussion

erceve's avatar
erceve
Helper I
6 years ago
Solved

Formula style differences between different machines

Hello, I have a problem where formula's work on one machine but not on the other. I've made a template file which my company can use as a base fro reporting, this file contains a calendar created wit...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi erceve ,

     

    This really looks a strange issue. Can you check your separator settings on your machine under Regional settings?

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi erceve ,

 

The first thing is that you haven't highlighted anything in RED in your DAX. Then going through your explanation, it looks like both the machines have a separator differently set-up, i.e Machine 1 has ';' (semicolon) and Machine 2 has ',' (comma).

 

Therefore your formula modofied itself from semicolon to comma. That looks perfect.

Try checking DAX on your MAchine 2 that every semicolon is correctly replaced by comma.

 

Also, it will be good to see the screesnhot of the DAXon Machine 2 here.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

erceve's avatar
erceve
Helper I
6 years ago

wow that is a quick reply, here is a screenshot from machine 2, as you can see everything appears to have been replaced correctly

 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi erceve ,

     

    Your DAX actually looks perfect to me. Can you share your .pbix file?

     

    Thanks,

    Pragati

    • erceve's avatar
      erceve
      Helper I
      6 years ago

      Here's a link for the pbix file, thx in advance!

       

      https://we.tl/t-H9rcsDZDWz  

       

      edit: here's also a screenshot of part of the error message (apologies for the akward format) in the error message it appears to replace the comma's with full stops, maybe it's nothing but it's something I noticed and thought might be relevant

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi erceve ,

         

        Thanks for sharing the pbix file. When I opened the pbix file, in your DAX I see "." not comma ","

        Screenshot as below:

        If your replace these highlighted DOT with COMMA, the DAX returns no errors. Can you please check this again?

         

        If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

         

        Thanks,

        Pragati