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:

Master Functions and Syntax in M

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

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#ConditionalReplace #PowerQuery #BIGorilla

Рекомендации по теме

Комментарии

Man! You saved me when ChatGPT and Copilot could not help, even in a task that seemed to be so simple.
Very thanks!

czyxlqe

Thanks a ton for explaining that so clearly. I especially appreciate the elegance of doing it all in one step. Bravo!

xyz

Note to self: To skip a line in the formula bar, press "Shift" + "Enter"

andyle

Simple, elegant, and well explained. Thanks!

milossubak

This video was so helpful! Exactly what I was looking for. I used criteria based on multiple fields for different scenarios. I used Each only once before the start of the if statements and it worked perfectly. Thank you!!!

RaisingBrows

@BIGorilla comes through again (and again and again)! Thank you SO much!

CAKimberlyLewis

Man, you just helped me with this week's work. So nicely explained, cheers!

adyelencu

Brilliant mate, this helped me so much. I have googled so much about this subject and couldn't find an easy way to do this, untill I stumbled upon your tutorial. Thanks!

walkurey

Thank you for a great explanation and solution!

carolineabrahamsson

Helpful and very good explained. Thank you.

lubomirjagersky

Good explanation make it easy to understand, thanks for sharing.

moyura

That was exactly what I was looking for! Thank you 🙏

users-pRs

This was really helpful. Thank you so much.

ahmadahmadsalim

This is BEAUTIFUL! Thanks dude, this vid helped a bunch!

tantewalla

Thank you mate, it was a big help to resolve an annoying bad clusterization problem (and ofc it saved me a lot of hours of research)

philipedesouzasantos

Chef's kiss for this one Rick 🙂 I wish the Power Query UI options for updating columns were as good as for adding columns but this is a great explanation and helped me out. Subscribed!

wken

Absolutely brilliant, this has saved my so much time and head-scratching! Thank you 🙂

stuartproctor

Oh my gosh. Why WHY DID I NOT WATCH THIS YEARS AGO!!!

samyoung

Thanks, great explanation and very helpful.

PeteMackay

I am so pleased with how you explain and teach! Thank you! I have subscribed and liked the video!

yasinwarsame

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

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

Replace Values in Multiple Columns Based on Condition in Power Query

Replace values in data table based on conditions in R

Power Query: How to mass replace values based on a list | Excel Off The Grid

43 - Replace values in a column based on conditions

R Replace Values in Data Frame Conditionally (4 Examples) | Exchange Value in Column & Entire Ma...

Replace values with values in other column - Power BI

PYTHON : Pandas DataFrame: replace all values in a column, based on condition

Live stream Python 10 hours part 94

Power Query Replace Values the safer way

Replace Multiple Column Values in One Step [Power Query Tips & Tricks]

Microsoft Excel 2016 - Using the REPLACE() Function

Power Query Tutorial: How to Conditionally Replace Values Without Creating New Columns

Replace multiple values in Power Query in one step

A_18: REPLACE COLUMN VALUES USING CONDITIONS IN PANDAS

Pandas Replace Cell Value Based on Condition

Conditional Column vs. Replace value in Power Query - Power BI Desktop Tips and Tricks (41/100)

Pandas DataFrame: replace all values in a column, based on condition

Learn Power BI: Power Query Conditional Replace Value AT131

29 - Replace the values in a column on a condition (Power Query)

Replace text with another column value in Power Query

Find and Replace Multiple Values in Excel - ALL AT ONCE!

Power Query - Bulk Replace Values in One Step 🔄📊

Replace Multiple Values in Several Columns of Data Frame in R (2 Examples) | sapply() & replace(...