Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Add custom grouping

I have a need to group department information by commonly referred names non-existent in the data.  To use a grocery analogy, if I had commonly referred names of:

  • Produce
  • Bakery
  • Meat

Departments of: 

Department Number - Department Name

1234 - International Produce

1235 - Local Grown Veggies

1236 - Organic 

1237 - Full of Pesticides

2345 - Fresh Baked

2456 - Day Old

2567 - Baked to Order

3456 - Pre-Packaged

3567 - Cut to Order

3678 - Ready for the Grill

 

How would I add the commonly referred names then group the department information accordingly.

 

Thanks,

 

Larry Powell

 

 

Need Help
Show and Tell
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Anonymous Take a look at this DAX pattern. It looks like Static segmentation is what you are after.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    You could have a look at my Power BI lookup blog article here, this covers the topic pretty well.

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    10 years ago

    Anonymous

     

    In this scenario, it's better to add a category id column in both tables, and build the relationship based on this id column. You can hardly populate the commonly referred names based on Department Name matching only.

     

    Regards,