cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Calculate total weeks sales

I have tried several mesures and suggestions but can not figure this out.  My table has date week number and daily sales.

 

i want to calculate or create a col;unm that totals the whole weeks sales.  I have 7 week 12 entries as the week number is returned for each date entry.  Please help Screenshot 2019-12-12 at 10.37.45.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Calculate total weeks sales

@Anonymous 

 

By the looks of it you are actually getting the sum of sales by week (see second column: "Week Totals"). So what is it you are after?

If you create a table removing the Day column (and possibly the "daily totals Mes") you will get a table with only one  Line/value per week.

Or use a matrix visual instead of a table visual





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Calculate total weeks sales

@Anonymous 

 

By the looks of it you are actually getting the sum of sales by week (see second column: "Week Totals"). So what is it you are after?

If you create a table removing the Day column (and possibly the "daily totals Mes") you will get a table with only one  Line/value per week.

Or use a matrix visual instead of a table visual





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Highlighted
Anonymous
Not applicable

Re: Calculate total weeks sales

The Column ‘week totals’ is only returning the daily sales and not calculating the whole weeks sales in essence I need all 7 entries with the same week number to be calculated to make a total for that fiscal week. The week number recycles every year so will have to be separate for each fiscal year.

Highlighted
Super User II
Super User II

Re: Calculate total weeks sales

@Anonymous 

 

 

Ok... so what is your model structure? What column is the daily sales in? What relationship does your dCalender table have with your sales table?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors