Creating relationship between multiple tables from different months.

[tjthemute]

Hi All, 

I have just started using Power BI and I have a question about relationships between tables. I have multiple revenue reports from different months, and each report has identical column headings. How can I tell the program that these tables are related so I can show revenue of products over time? Do I have to aggregate all of the data into one table before bringing the data into BI, or is there a way in the program to get it to display revenue as a function time from monthly reports?

Thank you!

[paulag · Accepted solution]

In the query editor you can apend queriers and tables. Append means place one on top of the other.  

this might help you

https://support.office.com/en-ie/article/Append-queries-Power-Query-e42ca582-4f62-4a43-b37f-99e2b2a4...