Relating tables

[Oros]

Hello.

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

[v-henryk-mstf]

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

[aj1973]

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]

HI @aj1973 ,

How do you exactly combine these tables?  Thanks for your prompt help.

[aj1973 · Accepted solution]

@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