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

     

aj1973's avatar
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's avatar
    Oros
    Post Prodigy
    4 years ago

    HI aj1973 ,

     

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

    • aj1973's avatar
      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