How to recode Blank and Grace as Other ?

[admin11]

Hi All

Below syntax work fine  @v-yangliu-msft :-

GROUP_class_CO =

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE('SALES'[GROUP_CLASS_],

"G02","PAUL"),

"1","GRACE"),

"2","HELENE")

My PBI file :-

https://www.dropbox.com/s/bnbodhork69xenx/PBT_V2021_396%20TI_SI_GL%20SAMPLE.pbix?dl=0

Paul

[amitchandak]

@admin11 , Try a new column like

GROUP_class_CO =
if( isblank('SALES'[GROUP_CLASS_]) || search("1",'SALES'[GROUP_CLASS_],,0)>0, "Others",
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('SALES'[GROUP_CLASS_],
"G02","PAUL"),
"1","GRACE"),
"2","HELENE"))

[admin11]

@amitchandak 

Thank you for sharing , actually my requirement is i need to combine Blank and Other. may i know how to achieve this ?

[v-jingzhang · Accepted solution]

Hi @admin11 

Please try these codes:

GROUP_class_CO_NEW = 
IF ( SALES[GROUP_class_CO] IN { "GRACE", "" }, "Others", SALES[GROUP_class_CO] )

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.