How to force G16 recode to AO ?

[admin11]

Hi All

I have below workig fine expression from @pranit828  which recode the field GROUP_TYPE into only those value label i want to see :-

GROUP_TYPE_C = IF ( ISBLANK('Group TYPE'[GROUP_TYPE]), "No",if('Group TYPE'[GROUP_TYPE] in {"G1","G2","G3","G4","G5","G16"},'Group TYPE'[GROUP_TYPE], "Other"))

I have below expression from @v-yangliu-msft

 which help to recode G1 to GT , G2 to AP  .... etc  

GROUP_TYPE_CO =

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE('Group TYPE'[GROUP_TYPE_C],

"G1","GT"),

"G2","AP"),

"G3","SL"),

"G4","CL"),

"G5","RW"),

"G16","AO")

My issue is for G16 it should recode as AO , but it does not work fine , not sure where it the problem :-

 My PBI file :-

https://www.dropbox.com/s/eir99gl49rpi4ji/PBT_V2021_397%20TS_SI_GL%20recode%20G16%20to%20AO.pbix?dl=...

Paul

[amitchandak · Accepted solution]

@admin11 , Try like this as we are using a function that works on  *value*, it means G16 should come before G1

GROUP_TYPE_CO = 
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('Group TYPE'[GROUP_TYPE_C],
"G16","AO"),
"G2","AP"),
"G3","SL"),
"G4","CL"),
"G5","RW"),
"G1","GT")

[admin11]

@amitchandak 

no wonder you are supper user