Forum Discussion
Mahamood0218
4 years agoHelper II
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...
- 4 years ago
Hi Mahamood0218 ,
you can add a column with this formula:
Text.Trim([Values], "0") - 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
ImkeF
4 years agoCommunity Champion
Hi Mahamood0218 ,
you can add a column with this formula:
Text.Trim([Values], "0")
Mahamood0218
4 years agoHelper II