Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |