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 try a lot of times the reginal settings, but is a dead end.... do you know how can i made this happen in dax ?