Three Ways to add Leading Zeros to Numbers in Power Query

Three Ways to add Leading Zeros to Numbers in Power Query

23.040 Lượt nghe
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-leading-zeros/ 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_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #PowerQuery #LeadingZeros #BIGorilla