Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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,
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,
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |