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 could format it again as text, and format as you need it to, but this for sure not the goal, to have numbers formated as text in your data model.
Question: Why is even needed to have the setting like this in a data table?
Because when you are writing a dax-measure or use the formated data in your visualization, this is for sure not and issue to convert it back to a text again.
Hope it helps
Jimmy
The reason is pretty complex 🙂
The report is being exported to a CSV.
This has to be read in an application from another party.
For some strange reason they use ";" as separator.
So what we do with all other reports, after export, is changing the ", " to a ";"
However in this report the want the separator as ";" and the notation on money values as a "."
If we do the standaard trick al "," becomes "; " so then they got an issue with the money value.
You can imagine it drives me crazy 🙂
Hello Anonymous
sorry, I can't follow. I mean separating columns with ";" is just fine, and nothing has to be adapted prior importing. Just import the data, specifying ";" as separator. However, if the numbers withing the csv-file have this format 0,000.00 apply culture en-US, when it's like this 0.000,00 apply de-DE.
And if there is a need to format your final measures with the format 0,000.00 use the dax formula "Format".
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
JimmyIf i try to set the fomula
Kolom = FORMAT(FeitNVTZ[mBedragBetaald];000000000.00)Then directly after pushing enter it gets back toKolom = FORMAT(FeitNVTZ[mBedragBetaald];000000000,00)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