Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , A new column in DAX

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

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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.