Add custom grouping

[Anonymous]

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

[v-sihou-msft]

@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,

[Greg_Deckler]

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

[Seth_C_Bauer]

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