Three Ways to add Leading Zeros to Numbers in Power Query
This video shows three different ways to add leading zero's to numbers. Prefixing numbers can be beneficial to maintain a fixed data structure for your data.
Wanna know about another way? Read it here: https://gorilla.bi/power-query/add-le...
Master Functions and Syntax in M
https://powerquery.how
CHAPTER
00:00 Introduction
01:27 Method 1: Concatenate
02:47 Method 2: Text.Padstart
04:18 Method 3: Column from Examples
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#PowerQuery #LeadingZeros #BIGorilla