Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replace a cell in one column if another columns cell equals something

I have the following two columns

Current State
Service TypeResource Type
SCM301FT101
SCM301GT101
SCM100FT101
SCM100HM500
SCM075KL102
SCM050KL102
SCM100KL103
GL200FT101

 

I want to do the following

If "Resource Type" = FT101 Then "Service Type" =  FX008, Else keep Service Type as is

 

Here is what I want to end up with

 

Desired State
Service TypeResource Type
FX008FT101
SCM301GT101
FX008FT101
SCM100HM500
SCM075KL102
SCM050KL102
SCM100KL103
FX008FT101

 

Any suggests on how to go about this? 

Replace Values Based on Another Column
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous Please create a calculated column desired service type as 

    Desired Service Type = IF('Table'[Resource Type]="FT101","FX008",'Table'[Service Type])

    Please let me know if you have any question. If it help accept as solution 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous Please create a calculated column desired service type as 

    Desired Service Type = IF('Table'[Resource Type]="FT101","FX008",'Table'[Service Type])

    Please let me know if you have any question. If it help accept as solution 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous  worked perfectly, thanks so much.

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    You can do it in Power Query as an alternative.

    Select Yor column, go to Transform Ribbon > Replace Values > Value to Find = FT101  and Replace with = FX008 then Click Close and Apply

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.