cancel
Showing results for
Search instead for
Did you mean:
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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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.

3 REPLIES 3
Highlighted
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.

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

## 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

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

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### 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