Forum Discussion

Helper IV

4 years ago

Solved

Leading zero

Hi

I have a list of ID numbers and some of them are missing a leading zero, the ID number should be 8 digits long the IDs that need a leading zero are only 7 digits long. How do I add a leading zero to just the 7 digit IDs in the query editor?

thanks in advance

amitchandak
4 years ago
WJ876400 , use only one second is alternate

example

Text.PadStart(Text.From([Colum]),8,"0")

4 Replies

amitchandak
Super User
4 years ago
WJ876400 , In power query

Text.PadStart(Text.From([Colum]),8,"0")

Text.PadStart([Colum],8,"0")

DAX

format([Column], "00000000")

https://www.fourmoo.com/2015/03/25/power-query-adding-leading-zero-to-number-eg-month-number/

https://gorilla.bi/power-query/add-leading-zeros/
WJ876400
Helper IV
4 years ago
Hi amitchandak thank you for the quick response. I get an error on the custome column
- amitchandak
  Super User
  4 years ago
  WJ876400 , use only one second is alternate
  
  example
  
  Text.PadStart(Text.From([Colum]),8,"0")
v-yanjiang-msft
Community Support
4 years ago
Hi WJ876400 ,

Has your problem been solved by amitchandak 's solution? If yes, please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

Related content