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?  Thank...
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

     

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

Anonymous 

 

You can use union to join rows

 

jointable = UNION(Sheet17,Sheet18)