Replace if

[Anonymous]

There are data clean up required. I want to replace the status in the column "return reason" from FPC to FPR where the column "Model" is equal to "S123". Any advice?

[v-yalanwu-msft]

Hi, @Anonymous ;

Such as amitchandak said ,you could use replace value. 

and if you want to change a column and don't want to add a new column, may be you must complete it in power query.

One method is replace the value;

Another method is add a condition column then delete the original column.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , A new column in DAX

if([return reason] = "FPC" && "Model" = "S123" , "FPR", [return reason] )

[Anonymous]

Creating a new column is not my plan.

[amitchandak]

@Anonymous , Then you need to do it power query , refer

https://community.powerbi.com/t5/Desktop/Replace-value-in-Power-Query-based-on-condition/td-p/1367325