(DivideBy is 1 or 1000 depending on user preference).
This gives: 245 342,.32 if the original value is: 245,342.32 when DivideBy i 1 (if Divide by is 1000 then the result shows: 245,.34). The problem is that if i remove the dot in the format string everything gets messed up - and I dont want the dot in the end result obviously.
(I need the rest of the environment in english so I cant change culture - so that's not the solution unfortunately.)
Power bi desktop uses the number format as your system region and currency symbols settings. You can refer to amitchandak's links to modify them in your system settings but they will also affect the general numeric values stored in your system.
For format function, it will convert your number to text and display it with the specific format that you defined in the optional parameters.
I'd like to suggest you try to do formatting in your table field properties, it only changes the display value format and not affect the raw record values: