Concatenate values from related table as a calculated column?

[olimilo]

Say I have the following tables:

Project

PROJ_ID

123456

Samples

PROJ_ID		SAMP_ID		VAL
123456		123456		A
123456		123457		B
123456		123458		C

Is it possible to combine the Samples[VAL] values based on the PROJ_ID as a calculated column in the Project table?

Edit: I know I can do this via Power Query, but in this instance, it has to be done via DAX.

[ThxAlot]

Concat = CONCATENATEX( RELATEDTABLE('Sample'), 'Sample'[VAL], ", " )

[mlsx4 · Accepted solution]

Hi @olimilo 

You can create a new table with the following dax code, but I don't know if it is what you need:

naturalinnerjoin = 
    VAR
         LeftTable =
             SELECTCOLUMNS(
                 'Sample',
                 "PROJ_ID", 'Sample'[PROJ_ID] & "",
                 "VAL", 'Sample'[VAL]
             )
    VAR
        RightTable =
             SELECTCOLUMNS(
                 'Project',
                 "PROJ_ID", 'Project'[PROJ_ID1] & ""
             )
    RETURN
        NATURALINNERJOIN(LeftTable, RightTable)