Forum Discussion

PVO3's avatar
PVO3
Icon for Impactful Individual rankImpactful Individual
5 years ago

DAX Format EU numbers

Hello,   I'm looking for a solution to format my numbers to EU standards in DAX. This is mainly concerning thousand seperators. Read a lot of articles about converting my numbers to text, then rep...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi PVO3 ,

 

You could simply change the format of the column to Currency and choose a currency type.

 

Best Regards,

Jay

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Anonymous thanks for your reply. Like I mentioned I need a DAX solution. Your suggestion is static. What if I would like to use the measure for different scenario's? By using FORMAT i can do some adjustments but it has 2 downsides. I can't change the thousand seperator and it converts to string.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi PVO3 ,

       

      I don't quite understand the scenario. You could always use the data in measures or calculated columns and all you need is to change its display format.

      And as far as I know, there isn't a DAX function could get a numeric value with thousand seperator. 

      Hope others have a better solution.

       

      Best Regards,

      Jay