Create Table with rows from different tables

[Anonymous]

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 

[ryan_mayu · Accepted solution]

@Anonymous 

You can use union to join rows

jointable = UNION(Sheet17,Sheet18)

[Mariusz · Accepted solution]

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 · Accepted solution]

@Anonymous 

You can use union to join rows

jointable = UNION(Sheet17,Sheet18)