Forum Discussion

powerbiuser101's avatar
powerbiuser101
Advocate I
8 years ago
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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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.

    How_to_replace_text_based_on_filter1

    2. Open the Advanced Editor. Replace the 1 with the code below.

    each if [Main] = "Salad" and [Side] = "Apple" then "Orange Juice" else " "

    How_to_replace_text_based_on_filter2

     

    Best Regards,

    Dale

hiralsoni_001's avatar
hiralsoni_001
Frequent Visitor
7 years ago

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.