YTD sales per week by Reseller using ISO Week Number

Question

I am trying to calculate YTD sales per week for each reseller based on ISO WeekNumber. I have tried various measures and calculated columns such asYTDTest1 =CALCULATE(SUM( ResellerSales[NetSales] ),FILTER(ALL(ResellerSales),ResellerSales[WeekNumberISO] = ResellerSales[WeekNumberISO]-1))Is this possible get YTD updated for each WeekNumber per Reseller?I chose not to use a date field because based on week number. Would consider creating a Date Dimension if that will make this easier.My data looks like thisResellerIdWeekNumber ISOWeekNumber Year ISONetSalesCalc Reseller YTDCalc NetSales Weekly Rank1502019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 392.01&nbsp;&nbsp;1512019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 681.38&nbsp;&nbsp;1522019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350.47&nbsp;&nbsp;112020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 141.55&nbsp;&nbsp;122020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 764.44&nbsp;&nbsp;132020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85.25&nbsp;&nbsp;22502019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 767.09&nbsp;&nbsp;22512019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 495.98&nbsp;&nbsp;22522019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 872.44&nbsp;&nbsp;2212020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 630.64&nbsp;&nbsp;2222020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 309.46&nbsp;&nbsp;2232020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 62.06&nbsp;&nbsp;34502019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 269.23&nbsp;&nbsp;34512019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 151.98&nbsp;&nbsp;34522019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.16&nbsp;&nbsp;3412020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 762.61&nbsp;&nbsp;3422020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 771.34&nbsp;&nbsp;3432020&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 473.44&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

ren_steffen&nbsp;Seems like you need to add YEAR filter into your calculation, otherwise you will get weeks in previous years.

ren_steffen · Answer

With the current CALCULATE and FILTER there is no data returning. Same with adding a YEAR to the filter, and also adding a filter for store.&nbsp; If I filter to a SELECTEDVALUE( WeekNumber Field), with YEAR, it sums the same number for all years all records.

Forum Discussion

YTD sales per week by Reseller using ISO Week Number

2 Replies

Related content

Calculating Weighted Sales

% CT SALES

need to display monthly sales and 6 month average sales for products

Top 3 Average Sales mix

Help With Semantic Model - Different Sums & Counts for Sales in Specific Counties From Total Sales