Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding commas to a text numeric value

I have text type column1 which has  some numberic values.I want to put commas to the values, just like the screenshot shown above.. I tried like below... but not done correctly...Plse help te...
Need Help
Show and Tell
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    you can use this measure:

     

    Measure = 
var _text=MIN('Table'[Column1])
var _len=LEN(MIN('Table'[Column1]))
return 
SWITCH(TRUE(),
_len<=3,_text,
_len>3&&_len<=6,LEFT(_text,_len-3)&","&RIGHT(_text,3),
_len>6&&_len<=9,LEFT(_text,_len-6)&","&MID(_text,_len-5,3)&","&RIGHT(_text,3))

     

    result

     

     

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi Anonymous 

you can use this measure:

 

Measure = 
var _text=MIN('Table'[Column1])
var _len=LEN(MIN('Table'[Column1]))
return 
SWITCH(TRUE(),
_len<=3,_text,
_len>3&&_len<=6,LEFT(_text,_len-3)&","&RIGHT(_text,3),
_len>6&&_len<=9,LEFT(_text,_len-6)&","&MID(_text,_len-5,3)&","&RIGHT(_text,3))

 

result

 

 

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ... Outlet code is the TEXT ... have created matrix table and put outlet code in the values .... how to separate the figures in the table with comma .... check the highlighted table values ... need comma after 3 digit