topic Re: Remove zero's from column in Power Query

Remove zero's from column

Mahamood0218 — Fri, 29 Jul 2022 12:29:24 GMT

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

Re: Remove zero's from column

ImkeF — Fri, 29 Jul 2022 19:02:11 GMT

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

Re: Remove zero's from column

Jos_Woolley — Sat, 30 Jul 2022 05:50:54 GMT

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

Re: Remove zero's from column

Mahamood0218 — Mon, 01 Aug 2022 05:29:25 GMT

Jos_Woolley now dax fuction is working thanks for help.

Re: Remove zero's from column

Mahamood0218 — Mon, 01 Aug 2022 05:31:03 GMT

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