Forum Discussion

Mahamood0218's avatar
Mahamood0218
Helper II
4 years ago
Solved

Remove zero's from column

Hello PBI Experts ,

i have a requirement to remove leading 0 zero from table by using dax fucntion 

Output :

must be deine dax fuction could you please suggest this issue.

 

Thanks&Regards,

shaik

Need Help
Show and Tell
Tips and Tricks
  • Jos_Woolley's avatar
    Jos_Woolley
    4 years ago

    Since you asked for a solution in DAX, this Calculated Column:

     

    New Column =
VAR MyValue = 'Table'[Values]
VAR T1 =
    ADDCOLUMNS(
        GENERATE(
            VALUES( 'Table'[Values] ),
            GENERATESERIES( 1, LEN( 'Table'[Values] ), 1 )
        ),
        "MyChar", MID( 'Table'[Values], [Value], 1 )
    )
RETURN
    MID(
        'Table'[Values],
        MINX(
            FILTER( T1, 'Table'[Values] = MyValue ),
            IF( [MyChar] <> "0", [Value] )
        ),
        LEN( 'Table'[Values] )
    )

     

    Regards

4 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    4 years ago

    Hi Mahamood0218 ,
    you can add a column with this formula: 
    Text.Trim([Values], "0")

  • Jos_Woolley's avatar
    Jos_Woolley
    Solution Sage
    4 years ago

    Since you asked for a solution in DAX, this Calculated Column:

     

    New Column =
VAR MyValue = 'Table'[Values]
VAR T1 =
    ADDCOLUMNS(
        GENERATE(
            VALUES( 'Table'[Values] ),
            GENERATESERIES( 1, LEN( 'Table'[Values] ), 1 )
        ),
        "MyChar", MID( 'Table'[Values], [Value], 1 )
    )
RETURN
    MID(
        'Table'[Values],
        MINX(
            FILTER( T1, 'Table'[Values] = MyValue ),
            IF( [MyChar] <> "0", [Value] )
        ),
        LEN( 'Table'[Values] )
    )

     

    Regards