Hi, I am facing an issue where the DAX FORMAT formula is not honoring the locale of the user. For example, in Dutch, the thousand separator is typically a dot (.) while the decimal separator is ...
Joris_NL
Helper III
Helper IIIHad the same issue, but solved it.
By multiplying the DAX FORMAT formula by 1, it resets the use of points and comma's back to regional settings. Afterwards, use the the standard formatting tab to get what you want.
Example:
MeasureNotWorking = format([VarianceAbsolute]);"€0.00")
which for example results in €12,345.66
Which is wrong in this case (Dutch)
MeasureWorks = format([VarianceAbsolute]);"0.00")*1
Then set the format tab to 'currency' with two digits. Results in: €12.345,66
Right?