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