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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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