Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to Solution.
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! 👍🤠
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
82 | |
67 | |
61 | |
46 | |
45 |