Forum Discussion

Tejasvi_munge's avatar
Tejasvi_munge
Frequent Visitor
6 years ago
Solved

Thousand separator using DAX

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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()

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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()

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

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