Forum Discussion
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
Hello Patfor
what about instead of replacing, you can add a conditional column, then remove the older column if you want :
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! 👍🤠
2 Replies
Hello Patfor
what about instead of replacing, you can add a conditional column, then remove the older column if you want :
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!
