Forum Discussion
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&R...
Hi Mahamood0218 ,
you can add a column with this formula:
Text.Trim([Values], "0")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
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
