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
Date calculations: find the first Monday of the Next Month in Power Query
Power Query: How to mass replace values based on a list | Excel Off The Grid
Mastering the IF Function in Power Query - including Nested-IF statements (Complete Guide)
The Magic of working with Records in Power Query
Replace Values in Multiple Columns Based on Condition in Power Query
Learn to Automate Everything with Power Query in Excel (Download Files)
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
Power Query was HARD until I learned these 7 Tips
The Fastest Replace Values method using a list in Power Query
SWITCH Function in Power Query
Reduce Steps in Power Query - Tips Only the Pros Know!
7 Power Query Tricks You’ll Regret Not Knowing
Power Query Tutorial: How to Conditionally Replace Values Without Creating New Columns
Conditional JOIN using Power Query | A different way of merging in Power BI
List.Generate in Power Query - Tutorial with Easy Examples
APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table
Transform Column Names in Bulk in Power Query
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
each & underscore_ in Power Query Explained
