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
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