Forum Discussion

jfranch's avatar
jfranch
Regular Visitor
6 years ago
Solved

Concatenate related values

Hi all,   I would like to make a calculated column with N referenced values.   I have this three tables:   Projects: Resources: Asignments: An this is the matrix I need: ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi jfranch ,

     

    Create the following measure:

     

    Projects = CONCATENATEX(Assignments;RELATED(Projects[Name]);",")

     

    Check PBIX file attach.

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

Hi jfranch ,

 

Create the following measure:

 

Projects = CONCATENATEX(Assignments;RELATED(Projects[Name]);",")

 

Check PBIX file attach.

  • jfranch's avatar
    jfranch
    Regular Visitor
    6 years ago

    Many thanks,

     

    Works like a charm!

     

    Best regards