cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oros
Helper IV
Helper IV

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.

 

Oros_0-1654286157799.png

Oros_2-1654286229351.png

 

Oros_3-1654286298046.png

 

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

@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

aj1973_0-1654288334548.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

4 REPLIES 4
v-henryk-mstf
Community Support
Community Support

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
Community Champion
Community Champion

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. 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

HI @aj1973 ,

 

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

aj1973
Community Champion
Community Champion

@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

aj1973_0-1654288334548.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors