cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
leahschneider
Helper III
Helper III

Replace Value in Multiple Columns Conditionally

I have a table in Power Query and I need to replace values across multiple columns if one column has a particular value. I've used https://gorilla.bi/power-query/replace-values/#conditional-replace-single-step and it seems sort of helpful but I want to replace the value based on the value in the table and not just to a static number.

To use the example in that website...

Instead of this:

 

= Table.ReplaceValue(
#"Removed Other Columns",
each [Income] > 50000,
each 2,
(x,y,z)=> if y then z else x,
{"Kidhome", "Teenhome"}
)

I need:

= Table.ReplaceValue(
#"Removed Other Columns",
each [Income] > 50000,
each [whatever the value is in the column] * 2,
(x,y,z)=> if y then z else x,
{"Kidhome", "Teenhome"}
)

 

Can anyone help?

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @leahschneider 

 

have a try

= Table.ReplaceValue(
#"Removed Other Columns",
each [Income] > 50000,
null,
(x,y,z)=> if y then x*2 else x,
{"Kidhome", "Teenhome"}
)

View solution in original post

2 REPLIES 2
leahschneider
Helper III
Helper III

Thank you so much. This is really tough for me.

Vera_33
Resident Rockstar
Resident Rockstar

Hi @leahschneider 

 

have a try

= Table.ReplaceValue(
#"Removed Other Columns",
each [Income] > 50000,
null,
(x,y,z)=> if y then x*2 else x,
{"Kidhome", "Teenhome"}
)

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors