Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

One to Many Join not working

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 !

 

Need Help

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Jihwan_Kim
        Super User
        3 years ago

        Hi,

        Thank you for your message.

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