cancel
Showing results 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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

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?

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Announcements

Power Platform Community Conference

Check out the on demand sessions that are available now!

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021