topic Combining tables with the same columns in DAX Commands and Tips

Combining tables with the same columns

ratgdillon — Mon, 21 Sep 2020 18:53:29 GMT

Hi all,

I have a growing list of monthly tables with the same format that I would like to combine into one long summary table. What is the most efficient way to combine all rows of my tables into one table? The easier it is for someone with minimal coding experience to update this formula every month, the better.

Thanks!

July Table:

Date	Product	Sales
7/4/19	Pepsi	$299
7/13/19	Coca-Cola	$283
7/23/19	Pepsi	$238

August Table:

Date	Product	Sales
8/1/19	Pepsi	$283
8/19/19	Coca-Cola	$123
8/26/19	Pepsi	$234

September Table:

Date	Product	Sales
9/9/19	Coca-Cola	$345
9/12/19	Coca-Cola	$394
9/20/19	Pepsi	$832

Summary Table:

Date	Product	Sales
7/4/19	Pepsi	$299
7/13/19	Coca-Cola	$283
7/23/19	Pepsi	$238
8/1/19	Pepsi	$283
8/19/19	Coca-Cola	$123
8/26/19	Pepsi	$234
9/9/19	Coca-Cola	$345
9/12/19	Coca-Cola	$394
9/20/19	Pepsi	$832

Re: Combining tables with the same columns

lbendlin — Mon, 21 Sep 2020 22:54:14 GMT

There's no need to update anything manually. You create a Power Query source that points to a folder rather than a file. Then you can collect all the files in that folder and combine them into a single query. Newly added files will automatically be included on the next refresh.

Re: Combining tables with the same columns

ratgdillon — Tue, 22 Sep 2020 17:01:41 GMT

lbendlinHow would I do that?

Re: Combining tables with the same columns

lbendlin — Tue, 22 Sep 2020 17:03:43 GMT

use the Folder Source in Power Query and let it guide you through the steps.