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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Patfor
New Member

Issue with replacing using multiple conditions in Power Query Editor

Hello, I'm trying to use this formula to fill in "0 - 10" in the field called Value_Range

This has multiple conditions for Power Query Editor but I do not know what I'm missing because its not filling in.

 

= Table.ReplaceValue(#"Replaced Value44",

each [Value_Range],

each if [Domains] = "Income Disparity" and [value] >= 0 and [value] <= 10 then "0 - 10" else [Value_Range],

Replacer.ReplaceText,{"Value_Range"})

 

So, I'm trying to say... In the column called Domains where there is a string = "Income Disparity" AND also in the column called [value] if the value is = or > 0 and = < 10, then replace whatever is in the column Value_Range with "0 - 10" 

I will also have to add another condition for "11 - 20" and another for "21 - 30" 

Thanks 

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

Hello @Patfor 

 

what about instead of replacing, you can add a conditional column, then remove the older column if you want : 

Daniel29195_1-1706395192808.png

 

 

 

let me know if it works for you . 

 

 

 

If my answer helped sort things out for you, feel free to give it a thumbs up and mark it as the solution! It makes a difference and might help someone else too. Thanks for spreading the good vibes! 👍🤠

View solution in original post

2 REPLIES 2
Daniel29195
Super User
Super User

Hello @Patfor 

 

what about instead of replacing, you can add a conditional column, then remove the older column if you want : 

Daniel29195_1-1706395192808.png

 

 

 

let me know if it works for you . 

 

 

 

If my answer helped sort things out for you, feel free to give it a thumbs up and mark it as the solution! It makes a difference and might help someone else too. Thanks for spreading the good vibes! 👍🤠

This is genius and I'm now seeing more places where I can use this! Thanks! If they added 1 more piece to this where they allowed you to create multiple arguments for each range.... like one condition from this column AND another condition from this other column THEN .... Anyways thanks again!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.