Concatenate related values

[jfranch]

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:

Anyone can help me on how to calculate this matrix cells?

Many thanks

[MFelix · Accepted solution]

Hi @jfranch ,

Create the following measure:

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

Check PBIX file attach.

[jfranch]

Many thanks,

Works like a charm!

Best regards