Adding commas to a text numeric value

[Anonymous]

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

test =
VAR right =RIGHT ( [column1], 3 )
VAR left =SUBSTITUTE ( [column1], right, "" )
RETURN
COMBINEVALUES ( ",", left, right)

[v-xiaotang · Accepted solution]

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]

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