How to recode 100 brand into 1 brand with Other Brand ?

[admin11]

Hi All

I have a Field name BRAND_ :-

 I like to recode the BRAND_ to BRAND_P only display "YASKAWA" Brand :-

BRAND_P =

IF ( 'SALES'[BRAND_] = Blank(),

"No Brand",if(SALES[BRAND_] in

{"YASKAWA"},

'SALES'[BRAND_], "Other"))

I get return with out YASKAWA brand :-

Can some one share with where go wrong ?

Paul

[PhilipTreacy · Accepted solution]

Hi @admin11 

Your BRAND_ column doesn't actually contain the string "YASKAWA".  It contains the strings " YASKAWA" and "YASKAWA "- note the leading and trailing space.

That's why your code isn't working.

Clean up the BRAND_ column by removing spaces - you can use Text.Trim in Power Query.

regards

Phil

[admin11]

@PhilipTreacy

Thank you for your input

it will help me save a lot of my time

Paul 

[VahidDM]

Hi @admin11 

Try this:

BRAND_P =
IF('SALES'[BRAND_]="YASKAWA","YASKAWA",blank())

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[admin11]

@PhilipTreacy @VahidDM 

The issue cause by below :-

BRAND_ =

IF(

'SALES'[BRAND_SAP_] & " " & 'SALES'[BRAND_5] = " ",

"No Brand",

'SALES'[BRAND_SAP_] & " " & 'SALES'[BRAND_5]

)

Paul

[PhilipTreacy]

Hi @admin11 

Download sample PBIX file

Create a new column using your code then it should work fine

Regards

Phil

[admin11]

Hi Philip

Thank you for your help.

I found the solution , it work fine now :-

FLAG_UR_SD_TDS = if('SALES'[STOCK_CODE] in {"URD110105","URD110110","URD110203","URD110205","URD110210","URD110216","URD110303","URD110305","URD110310","URD110312","URD110203","URD110203","N15975","N16049","N16338","N15528","N17094","N16912","N17748","N17877","N16049"},"1", "0")

[admin11]

@PhilipTreacy 

I have try on my PBI file , it dos not work.