Forum Discussion
Lookup Field
Yes, you can do this with CONCATENATEX() in DAX. I have a video tutorial describing various techniques for this sort of thing here if it helps - this is using a file source, not a SP list, but shows how to create the dimension table, relate them, then concatenate values with a comma between.
After expanding the department ID and getting the department name, can I group them back together? For example John Doe is in department Administration and Com'l Service. I want it grouped where John Doe is only listed once with Administation, Com's Service in the same department name field.
Yes, you can do this with CONCATENATEX() in DAX. I have a video tutorial describing various techniques for this sort of thing here if it helps - this is using a file source, not a SP list, but shows how to create the dimension table, relate them, then concatenate values with a comma between.
Your video was extremely helpful, thank you so much!!