Forum Discussion

Vicentbi's avatar
Vicentbi
Frequent Visitor
9 years ago
Solved

Getting Value Sum from previous week

Hi  I have been trying to get values for previous week, unfuntuanlly it was not as easy as getting from previous month, with previousmonth function.   I alreday used a grouped date on the left...
  • Baskar's avatar
    Baskar
    9 years ago

    Sorry Mistake is my side.

     

     

    Try this

     

    Pre Sales =
    var End_Date = MIN('Week Sales'[StartOfWeek]) -1
    var Start_Date = End_Date - 6
    return 
    CALCULATE(SUM('Week Sales'[Sales]),DATESBETWEEN('Week Sales'[Date],Start_Date,End_Date),ALLSELECTED('Week Sales'[StartOfWeek]))

     

     

    Small Change in your already existing formula .

     

    Change ALLExcpet into ALLSelected, It should work 

     

    If not let me know dude.

     

     

     

     

Vicentbi's avatar
Vicentbi
Frequent Visitor
9 years ago

Strange I do not see where I can attach a file.

I'm attaching it as a photo for now.

Do not know if it works.

 

This is not the data I was using orgnially but structure should be the same