Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Valuta decimal separator changing from comma to point

Hi, I want to change the local decimal separator voor Valuta in our dutch version being changed from comma to a point.   I tried to do it by change the reginonal settings to English (VS) and to ma...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Jimmy801 

    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 🙂

     

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Jimmy801 

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 🙂