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:
gorilla.bi/power-query/replace-values/

Master Functions and Syntax in M
powerquery.how

If you want to learn how to do this for multiple columns, check out my other video: youtu.be/DLOvAc7IBrY

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: paypal.me/rickmaurinus.

Website: gorilla.bi

SUBSCRIBE TO MY CHANNEL
youtube.com/bigorilla?sub_confirmation=1

LET'S CONNECT:
Blog: gorilla.bi
Facebook: facebook.com/BIGorilla/
Twitter: twitter.com/rickmaurinus
LinkedIn: linkedin.com/in/rickmaurinus/

Thank you for your support!

#ConditionalReplace #PowerQuery #BIGorilla

• Replace Values Based on Condition (in a Single Step) in Power Query ( Download)
• Replace multiple values in Power Query in one step ( Download)
• Power Query - Conditionally replace values in one step! ( Download)
• Power Query Tutorial: How to Conditionally Replace Values Without Creating New Columns ( Download)
• Mastering Power Query: Conditionally Replacing Values ( Download)
• Learn Power BI: Power Query Conditional Replace Value AT131 ( Download)
• Conditional Column vs. Replace value in Power Query - Power BI Desktop Tips and Tricks (41/100) ( Download)
• Power Query Replace Values the safer way ( Download)
• Power BI quick trick…How To Conditionally Replace Values using if..then..else within replace! ( Download)
• How to extract text with an if condition in one step in Power Query ( Download)
• Power Query: Bulk Replace Values from a table in Excel & Power BI ( Download)
• Replace values with values in other column - Power BI ( Download)
• How To Perform Conditional Full and Partial Text Replacements In Power Query ( Download)
• INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel ( Download)
• Replace text with another column value in Power Query ( Download)