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:
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.
@lpowell Take a look at this DAX pattern. It looks like Static segmentation is what you are after.
You could have a look at my Power BI lookup blog article here, this covers the topic pretty well.
Proud to be a Datanaut!
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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!