Forum Discussion
Valuta decimal separator changing from comma to point
It finally worked.
I'd used the following formula:
EnglishFormat = SUBSTITUTE(FORMAT('Table'[Collumn], "#####0.00") ,",",".")
This makes the dutch format to English now. so the separator is changed from comma to point .
Thanx for you help 🙂
Hello Anonymous
you have to apply it like this
Power Query (german local setting):
if i want to have this number in a dax measure reformated lik 0,000.00 then the measure its like this:
SumNumberReformated = Format(Sum(Number[Number]);"#,##0.00 €")
here the final result:
In your case, you have it the other way round 😁
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
So,
When i try this i got an message of "to much arguments for function 'SUM'
Then i'd made a few adjustments butr very time there is a unwanted result.
It finally worked.
I'd used the following formula:
EnglishFormat = SUBSTITUTE(FORMAT('Table'[Collumn], "#####0.00") ,",",".")
This makes the dutch format to English now. so the separator is changed from comma to point .
Thanx for you help 🙂
Hello Anonymous
witch column are you referencing?
Could this column already be formated as text?
Jimmy
Hi Jimmy,
Tje collumn im reffering to is called "gedeclareerd"
This collum can't be reformated as tekst in the model setting.
Hello Anonymous
what I meant is that I can't see that column on the screenshot. And I'm asking myself if this column maybe is already formated as text.
Because the format-function is for sure the function to use, and it works as I proposed.
Jimmy
Hello
i would appreciate if you could mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy