Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to write a query to replace text but only based on values of another column. Example:
Main | Side | Drink | Price |
Burger | Soda | 5.00 | |
Fries | Soda | 2.00 | |
Burger | Fries | Soda | 7.00 |
Salad | 2.50 | ||
Salad | Apple | 3.00 |
I want to replace the blanks in [Drink] with "Orange Juice" only if [Main] = "Salad" and [Side] = "Apple". Using the GUI and simply replacing texts didn't help me since it still filled all the blanks in [Drink]. Not sure how to procede and I'd rather avoid creating a calculated column
Solved! Go to Solution.
Hi @powerbiuser101,
1. In the Query Editor, right click the blanks in the column Drink, then select Replace Values. Enter 1 to the Replace with.
2. Open the Advanced Editor. Replace the 1 with the code below.
each if [Main] = "Salad" and [Side] = "Apple" then "Orange Juice" else " "
Best Regards,
Dale
Hi there,
I am trying to replace values in a column where if value is M is replaced by Para Assement and when its 17 it should be replaced with Master's Degree, but when I replace M by Para Assement then it also replaces and overrites all values in 17 as 'Para Assementaster's Degree'.
How to correct this now. Please help
Thanks.
Hi @powerbiuser101,
Could you please mark the proper answer as the solution?
Best Regards,
Dale
Hi @powerbiuser101,
1. In the Query Editor, right click the blanks in the column Drink, then select Replace Values. Enter 1 to the Replace with.
2. Open the Advanced Editor. Replace the 1 with the code below.
each if [Main] = "Salad" and [Side] = "Apple" then "Orange Juice" else " "
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |