Forum Discussion
Thousand separator for General Number
Hi,
I have a column that displays the amount in 180+ currencies. I want to add a thousands comma seperator to it. Currently the value is a General Number. Whenever I try to add the comma seperator, from the Measure Tools tab, it automatically changes the format to decimal number. But for different currencies, the number of decimal places needed is different.
Ex: JPY has 0 decimal places but KWD has 3 decimal places.
How can I add commas to the amount without rounding up or down the number and not using fixed decimal places?
Thank you!
HI sprakash99,
AFAIK, current you can't set multiple format rules in the same table numeric field.
I'd like to suggest you write a measure formula with if statements and format functions to dynamically change the output string with different formats. (notice: when you use the format function, it will convert the result to text type)FORMAT function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
5 Replies
- mh2587
Super User
Measure = CONCATENATE('Table Name'[Column Name],",000")
This will just add ",000" to my existing amount.
Ex: 563.76 will become 563.76,000- mh2587
Can you please explain the expected output
HI sprakash99,
AFAIK, current you can't set multiple format rules in the same table numeric field.
I'd like to suggest you write a measure formula with if statements and format functions to dynamically change the output string with different formats. (notice: when you use the format function, it will convert the result to text type)FORMAT function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
