Replace Values Based on Condition (in a Single Step) in Power Query

This video teaches how you can replace values based on a condition. All in a single step! You can for example replace all negative numbers by 0, and leave the remaining numbers untouched. In addition, this method allows you to easily replace values based on another column. WRITTEN BLOGPOST: The ultimate guide to replacing values in Power Query, find it here: https://gorilla.bi/power-query/replac... Master Functions and Syntax in M https://powerquery.how If you want to learn how to do this for multiple columns, check out my other video:    • Replace Values in Multiple Columns Based o...   Chapters: 00:00 Introduction 00:16 The dataset 00:40 Creating a temporary helper column 01:21 Replace values based on a condition 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_con... LET'S CONNECT: Blog: https://gorilla.bi Facebook:   / bigorilla   Twitter:   / rickmaurinus   LinkedIn:   / rickmaurinus   Thank you for your support! #ConditionalReplace #PowerQuery #BIGorilla