Newbie needs help combining monthly sales columns

[AwfullHawfull]

Help Please, I am trying to create a total monthly sales for the company. Currently the sales are broken down on different excel spread sheets by department, and then I have seperate columns for mm/yy and that sales entry. There are multiple sales entries per month

for example dept A spreadsheet

month     item  sales $

Dec-18	xs	$18.00
Dec-18	xd	$12.00
Dec-18	xs	$18.00
Jan-19	xd	$12.00
Jan-19	xd	$12.00
Jan-19	xc	$5.00
Jan-19	xc	$5.00
Jan-19	xs	$18.00
Jan-19	xc	$5.00
Feb-19	xc	$5.00
Feb-19	xc	$5.00
Feb-19	xs	$18.00
Feb-19	xs	$18.00
Feb-19	xc	$5.00
Feb-19	xc	$5.00
Mar-19	xx	$25.00
Mar-19	xs	$18.00
Mar-19	xc	$5.00

department b spreadsheet

month     item  sales $

Dec-18	jk	$15.00
Dec-18	we	$10.00
Jan-19	jk	$15.00
Jan-19	xc	$5.00
Jan-19	xc	$5.00
Jan-19	jk	$15.00
Jan-19	xc	$5.00
Jan-19	xc	$5.00
Feb-19	xc	$5.00
Feb-19	jk	$15.00
Feb-19	jk	$15.00
Feb-19	xc	$5.00
Feb-19	xc	$5.00
Feb-19	xx	$25.00
Mar-19	jk	$15.00
Mar-19	xc	$5.00
Mar-19	we	$10.00
Mar-19	we	$10.00

the totals I need are total by month for the combined charts

like this

Dec-19		$63.00
Jan-19		$102.00
Feb-19		$126.00
Mar-19		$88.00

so I can make a dashboard visual of the entire companies sales by month.    Thank you for any help you can give.

[MFelix · Accepted solution]

Hi @AwfullHawfull ,

First of all you need to create a single table with all the spreadsheets you have. If the spreadsheets are on the same file follow this link to get them into a single table if youhave more than one file follow this other link although is for Power Query it's the same steps on PBI.

Them just use the unique table to make your visuals.

Regards,

MFelix

[AwfullHawfull]

THANK YOU, this worked and I have what I need.  Now I am trying to figure out how to autorefresh the new form. 

---

@MFelix wrote:

Hi @AwfullHawfull ,

First of all you need to create a single table with all the spreadsheets you have. If the spreadsheets are on the same file follow this link to get them into a single table if youhave more than one file follow this other link although is for Power Query it's the same steps on PBI.

Them just use the unique table to make your visuals.

Regards,

MFelix

---

---

@MFelix wrote:

Hi @AwfullHawfull ,

First of all you need to create a single table with all the spreadsheets you have. If the spreadsheets are on the same file follow this link to get them into a single table if youhave more than one file follow this other link although is for Power Query it's the same steps on PBI.

Them just use the unique table to make your visuals.

Regards,

MFelix

---

[MFelix]

Hi @AwfullHawfull ,

What do you mean with " autorefresh the new form. "

Regards,

MFelix