Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsTHANK 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
Hi @AwfullHawfull ,
What do you mean with " autorefresh the new form. "
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |