Forum Discussion

krdavies's avatar
krdavies
Icon for Helper I rankHelper I
6 months ago
Solved

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 a...
Need Help
  • MFelix's avatar
    MFelix
    6 months ago

    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.

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 months ago

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.

 

  • krdavies's avatar
    krdavies
    Icon for Helper I rankHelper I
    6 months ago

    Thank you! This worked perfectly and I've learned something new that I can see will be very useful in other areas. 

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      6 months ago

      Hi krdavies ,

       

      Don't forget to accept the correct answer so it can help others.