Thousand separator using DAX

[Tejasvi_munge]

Hi Team,

Suppose, I have value - 234384.

And I need formatting like 2,34,384 not 234,384 using DAX as I am using it in dynamic formatting measure.

Thank You.

[tex628]

I'm guessing that you are OK with having the values in text format?

[Anonymous · Accepted solution]

So you want commas placed at specific points in the value? Will it be the same point everytime? For that number you could write a Concatante() function using Left() Middle() and Right()

[Tejasvi_munge]

No, everytime there will be different values

[Anonymous]

Do you want to be placing them in a consistent location in the value?

[Anonymous]

So for that number in your post the formula you could use is:

With Commas = CONCATENATE(LEFT('Table'[Column1], 1), CONCATENATE(",", CONCATENATE(MID('Table'[Column1], 2, 2), CONCATENATE(",", RIGHT('Table'[Column1], 3)))))