Forum Discussion

WJ876400's avatar
WJ876400
Icon for Helper IV rankHelper IV
5 years ago
Solved

Adding 0 to id number

Hi   I have numerous spreadsheets and other source data that have an ID number, some sources have the ID with a 0 at the beginning and some dont and on my final input I have removed the 0. now I wa...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    WJ876400 

    you can also use DAX to create a column

    Column = FORMAT('Table (2)'[Column1],"00000000")

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

WJ876400 

you can also use DAX to create a column

Column = FORMAT('Table (2)'[Column1],"00000000")