Forum Discussion

sidds_sriv's avatar
sidds_sriv
Regular Visitor
10 years ago
Solved

Last 2 weeks sales

Hi,   I have a sales data on daily basis for each store-sku combinations....From this i am creating weekly report. For each week, we are taking sum of sales, etc...The data start from week number 6...
Need Help
  • AlexChen's avatar
    AlexChen
    10 years ago

    Hi,

     

    For example,  Your sales table is like below:

     

     

    You can create a measure to calculate the sum of salesAmount of weeknum 6 and 7:

     

     last2WeeksAmount = CALCULATE(sumx(sales, sales[salesAmount]),Filter(ALL(sales), sales[weeknum]=max(sales[weeknum])-1 || sales[weeknum] = MAX(sales[weeknum])-2))

     

     

    Best Regards

    Alex

     

     

AlexChen's avatar
AlexChen
Microsoft Employee
10 years ago

Hi,

 

For example,  Your sales table is like below:

 

 

You can create a measure to calculate the sum of salesAmount of weeknum 6 and 7:

 

 last2WeeksAmount = CALCULATE(sumx(sales, sales[salesAmount]),Filter(ALL(sales), sales[weeknum]=max(sales[weeknum])-1 || sales[weeknum] = MAX(sales[weeknum])-2))

 

 

Best Regards

Alex

 

 

  • sidds_sriv's avatar
    sidds_sriv
    Regular Visitor
    10 years ago

    Thanks Alex, it worked...really appreciated...

     

    Just wanted to know if I need to caclulate Last 2 week sales for a particular product/category...for example for Car/Gun then how should i change the query.

  • vrocca's avatar
    vrocca
    Advocate IV
    8 years ago

    How does this behave for the first week of the year? 

     

    Thanks