Forum Discussion

aishak12's avatar
aishak12
Helper IV
4 years ago
Solved

Transform column (removing characters)

All,   I have column1 where I want to create a new column while removing some characters.     So Column1: 123456789   I want to create a new column2: 1234     Any suggestions?
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, aishak12 ;

    You could create a column by dax.

     

    Column2 = LEFT([Column1],4)

     

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, aishak12 ;

You could create a column by dax.

 

Column2 = LEFT([Column1],4)

 

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.