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.

     

     

     

     

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool, Try this one .

 

Days Count =


var end_Date = MIN('Date Master'[Date]) -- To get End of previous week


var start_Date = end_Date -6 -- To get Start of Previous week in 7 Days Difference.


return CALCULATE(COUNT('Date Master'[Date]),ALLEXCEPT('Date Master','Date Master'[Date]), DATESBETWEEN('Date Master'[Date],start_Date,end_Date))

 

Note : 

 

Your calculation also correct have to do one correction. 

Add ALL(Table Name)  in your calculation, or AllExcept (Perticular Date Column)

 

Try this too.