Forum Discussion
Concat two values from dimension table into fact table
Hello everyone,
I am working with a database tracking workshop registration. I have registrations and workshops as fact tables and a number of dimension tables handling participant, instructor and series data. A workshop can have multiple instructors and I would like to be able to show in a table the details of a given workshop with both instructors on the same line but I'm not sure where to start. I am attaching a sample version of the dashboard. You will be able to see that 5 workshops in my dataset have 2 instructors each. My goal is for the workshops to appear once in the table with data in the instructor column showing Name1, Name2.
Sample dashboard: https://drive.google.com/file/d/1wNJIFuhfSeWsuIQMbme6fyN9oIZVLZSq/view?usp=sharing
Hi krdavies,
Create a measure with the following code:
Instructors = IF(ISINSCOPE(Workshops[Workshop title]), CONCATENATEX(VALUES(Instructors[Instructor name]), Instructors[Instructor name],", "))See file attach.