Remove Leading Zeros from Text in Power Query

This video shows how you remove leading zeros from a string in Power Query. This makes sure all characters in a value remain (even zeros), except the zeros at the beginning. Master Functions and Syntax in M https://powerquery.how 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. Website: https://gorilla.bi 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! Chapters: 00:00 Introduction 00:20 The dataset 00:41 Remove leading zeros in custom column 01:51 Remove leading zeros in single step #LeadingZeros #PowerQuery #BIGorilla