Forum Discussion

Post Prodigy

4 years ago

Solved

Relating tables

Hello.

I have 4 tables that are not related to each other. How do I achieve the RESULTING TABLE (please see below). Thanks.

aj1973
4 years ago
Oros
2 ways
1- import the 3 excel/csv files into power bi and the use the Combine botton to let Power bi do the work for you

OR

2- Import the 3 files into power query and then use

4 Replies

aj1973
Community Champion
4 years ago
Hi Oros
Combine A, B and C into D Table. Attach D to the Shipping department table through Sales order. In power bi convas build your visual or the resulting Table.
- Oros
  Post Prodigy
  4 years ago
  HI aj1973 ,
  
  How do you exactly combine these tables? Thanks for your prompt help.
  - aj1973
    Community Champion
    4 years ago
    Oros
    2 ways
    1- import the 3 excel/csv files into power bi and the use the Combine botton to let Power bi do the work for you
    
    OR
    
    2- Import the 3 files into power query and then use
v-henryk-mstf
Community Support
4 years ago
Hi Oros ,

Whether the advice given by aj1973 has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry