One to Many Join not working

[Anonymous]

Dear Community !

I have two tables: Where, 'Table A' Contains unique client list, while Table B contains related client data, say Client Name, topic_1, topic_2 & topic_3. What I need is Table C, with 'ALL' Clients from 'Table A' mapped to respective rows of Table B, even if some of the Clients (ex: Client_3) don't have a mapping data (i.e., those Clients data missing in Table B).

(P.S: Table C is Min of the values in Table B)

Please see attached image:

Thanks in advance !

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new calculated table.

New Table C =
ADDCOLUMNS (
    DISTINCT ( TableA[Client] ),
    "Param_1", CALCULATE ( MIN ( TableB[Param_1] ) ) + 0,
    "Param_2", CALCULATE ( MIN ( TableB[Param_2] ) ) + 0,
    "Param_3", CALCULATE ( MIN ( TableB[Param_3] ) ) + 0,
    "Param_4", CALCULATE ( MIN ( TableB[Param_4] ) ) + 0
)

[Anonymous]

Worked like a charm ! THANK YOU...

One more help please: Suppose Table A had 2 more columns (say: 'Topic 1', 'Topic 2'), how to populate those columns also into Table C?

Many Thanks in advance !

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message.

Please check the below picture and the attached file, that I amended.

[Anonymous]

Exactly what I needed ! THANK YOU !