Forum Discussion

Oros's avatar
Oros
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.        
Need Help
  • aj1973's avatar
    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

     

v-henryk-mstf's avatar
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