Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.