Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create Table with rows from different tables

Hello! 

I'm new in Power BI nad I need help to create a table that simply yoin rows from other 4 tables. 

The struture of all tables is the same (ID, Date, Value, Type).

 

Is it possible? 

Thanks 

Barbara 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

     

    You can use union to join rows

     

    jointable = UNION(Sheet17,Sheet18)

     

     

     

  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    You can Append Queries in Power Query as in the video below.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    6 years ago

    Anonymous 

     

    You can use union to join rows

     

    jointable = UNION(Sheet17,Sheet18)

     

     

     

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    You can Append Queries in Power Query as in the video below.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn