Forum Discussion
Replace if
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?
Anonymous , A new column in DAX
if([return reason] = "FPC" && "Model" = "S123" , "FPR", [return reason] )
4 Replies
- amitchandak
Super User
Anonymous , A new column in DAX
if([return reason] = "FPC" && "Model" = "S123" , "FPR", [return reason] )
- amitchandak
Anonymous , Then you need to do it power query , refer
v-yalanwu-msftCommunity Support
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.