Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
@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,
You could have a look at my Power BI lookup blog article here, this covers the topic pretty well.
@Anonymous Take a look at this DAX pattern. It looks like Static segmentation is what you are after.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.