Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Specifying thousand separator dax function

Hello,    I currently have a measure that makes a count. and what I wanted was for the thousands to be separated. but the only option that appears to me is to put the comma.            ...
Need Help
Show and Tell
Tips and Tricks
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    I create a sample as below:

    Then i create a measure to test:

    Measure 1 = SUM('Table'[Value])

    Then try this measure:

    Measure 2 = 
VAR t =
    SUM ( 'Table'[Value] ) & ""
VAR t1 =
    GENERATESERIES ( 1, LEN ( t ) + ROUNDDOWN ( LEN ( t ) / 3, 0 ), 1 )
VAR t2 =
    ADDCOLUMNS (
        t1,
        "Char", IF (
            [Value] / 4
                = ROUND ( [Value] / 4, 0 ),
            ".",
            MID ( t, LEN ( t ) - [Value] + 1 + ROUNDDOWN ( [Value] / 4, 0 ), 1 )
        )
    )
VAR result =
    CONCATENATEX ( t2, [Char], "", [Value], DESC )
RETURN
    result

    The result shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous , i'm sorry, but no. that is not what i'm looking for....

     

     

    what I want, is that instead of being separated by a comma(,) it's separated by a dot(.) (it's an integer without decimal places)

     

     

     

    Best Regards, 

    JO

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

       

      I have shared one link in last reply have you tried it?

       

      You need to change region setting.

       

      Thanks,

      Pravin