How to recorde Brand_ field into 4 core Brand ?

[Paulyeo11]

Hi All

My report have many Brand , i need to recode into only brand i high light below. Hope some one can advise me.

My PBI file :-

https://www.dropbox.com/s/nebk80zid6lasps/SI_TDS_V68%20record%20brand.pbix?dl=0

[ryan_mayu · Accepted solution]

@Paulyeo11 

maybe you can try use grouping and binning

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

[Anonymous · Accepted solution]

Hi, in your custom column, I updated it to this:

BRAND_ = IF ( 'SALES'[BRAND] = Blank(), "No Brand",if(SALES[BRAND] in {"HMS","HAKKO","GE"},'SALES'[BRAND], "Other"))

Maybe you could try it. Thanks!

[Paulyeo11]

Hi Sir

This is what i am looking for.

Thank you very much

Paul

[ryan_mayu · Accepted solution]

@Paulyeo11 

maybe you can try use grouping and binning

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning