Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors