Forum Discussion
Solved
How to replace text based on filter?
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 Sod...
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 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