adding zeros to make all numbers 3 digits using Power Query.

[lastnn30]

Hi

In Power Query, how can I make sure all numbers in a column are for example 3 digits. For example if I have number like 6 then I want it to be 006 if the number was 10 I want it 010, if  a number is 333, it will stay as it is. Thank you very much for your help in advanced.

[rsbin · Accepted solution]

@lastnn30 ,

A quick google search gave me these links:
https://radacad.com/add-leading-zeros-to-a-number-in-power-bi-using-power-query

https://gorilla.bi/power-query/add-leading-zeros/

Please note that adding leading zeros will convert your numerical columns into text columns.

Hope this helps.

Regards,