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, ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Thank you for your message.

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

     

     

     

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.

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Exactly what I needed ! THANK YOU !