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:

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

 

Many thanks

2 Replies

  • Hi jfranch ,

     

    Create the following measure:

     

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

     

    Check PBIX file attach.

    • jfranch's avatar
      jfranch
      Regular Visitor

      Many thanks,

       

      Works like a charm!

       

      Best regards