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

[Allan77R2V1]

I have the following two columns

Current State
Service Type	Resource Type
SCM301	FT101
SCM301	GT101
SCM100	FT101
SCM100	HM500
SCM075	KL102
SCM050	KL102
SCM100	KL103
GL200	FT101

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 Type	Resource Type
FX008	FT101
SCM301	GT101
FX008	FT101
SCM100	HM500
SCM075	KL102
SCM050	KL102
SCM100	KL103
FX008	FT101

Any suggests on how to go about this? 

[Mariusz]

Hi @Allan77R2V1 

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.

[Anonymous · Accepted solution]

@Allan77R2V1 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 

[Allan77R2V1]

@Anonymous  worked perfectly, thanks so much.