Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to recorde Brand_ field into 4 core Brand ?

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

 

Paulyeo11_0-1604969432545.png

 

2 ACCEPTED SOLUTIONS
ryan_mayu
Super User
Super User

@Paulyeo11 

maybe you can try use grouping and binning

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Anonymous
Not applicable

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!

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Impactful Individual
Impactful Individual

Hi Sir

This is what i am looking for.

Thank you very much

Paul

 

ryan_mayu
Super User
Super User

@Paulyeo11 

maybe you can try use grouping and binning

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.