Forum Discussion
Trouble with Format function when concatenating a string, locale is not respected
Hi, Im trying to create a text string that concatenates both a numeric value and a decimal value. I'm using Text measure = FORMAT([Numeric value];"#,0") &" ( "&FORMAT([Decimal value...
Anonymous
I’ve got response from the Product Team.
The model's culture is en-US so it seems like it is created on an US English machine. DAX functions use locale derived from the culture set in the model, not on the machine which the model is used. Note that once a model is created, its culture cannot be changed.
Best Regards,
Herbert
v-haibl-msftthanks for the response, I have understood that the functions use the locale from the data model. But as I stated in my last post: regardless of my OS culture (which is set to sv-SE) all my new models still get the culture en-US. I'm using the august version of PBI Desktop with english language but I guess that should not matter?