Remove zero's from column

[Mahamood0218]

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

[ImkeF · Accepted solution]

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

[Jos_Woolley · Accepted solution]

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

[Mahamood0218]

@Jos_Woolley now dax fuction is working thanks for help.

[ImkeF · Accepted solution]

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

[Mahamood0218]

@ImkeF i have try your formula this is also working ,thanks for help.