Forum Discussion

sprakash99's avatar
sprakash99
Frequent Visitor
4 years ago
Solved

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, ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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