Below is an example if you have a requirement and you want to add a leading zero

Example: You have a Month Number that starts with “1”, and you want it to start with “01”

  1. In your Power Query Window, click on Add Custom Column and then put in the following syntax

    Text.PadStart(Text.From([Month]),2,”0″)

    1. NOTE: In the above example, we have our column name as Month
  2. So once completed it will look like the following:

0 thoughts on “Power Query – Adding Leading Zero to Number (EG: Month Number)”

Leave a Reply

Your email address will not be published. Required fields are marked *