Forum Discussion
Formula style differences between different machines
Here's a link for the pbix file, thx in advance!
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
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
Hi Pragati11
That is really strange, as you can see in my screenshots it shows as a comma in my editor, also if I copy and paste it from my editor into something like notepad++, but the error message shows dots. Replacing the dots with comma's doesn't work for me since powerbi appears to interpret them as dots, even when I edit in notepad and then copy and paste into the editor.
It appear I have found a solution for now and that is replacing all the faulty comma's with double comma's like so:
But I still feel like I shouldn't have to do this when switching between machines as it gets tedious really fast to have to manually check and or change this everytime when somebody else wants to work on a file on a different machine. ATM I don't have access to machine 1 on which this file was initially created so I'll go back and check what happens with when I open this pbix there again.
For now thanks a lot for your time!