cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Newbie needs help combining monthly sales columns

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

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Newbie needs help combining monthly sales columns

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

Proud to be a Datanaut!

3 REPLIES 3
Super User

## Re: Newbie needs help combining monthly sales columns

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

Proud to be a Datanaut!

Frequent Visitor

## Re: Newbie needs help combining monthly sales columns

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:

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:

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

Super User

## Re: Newbie needs help combining monthly sales columns

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

Regards,

MFelix