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] )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a new column is not my plan.