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

Can u please share some sample data . I will help u 

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

 

 

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    Do u have Continuos date in your Table ?

     

    • Vicentbi's avatar
      Vicentbi
      Frequent Visitor
      9 years ago

      I believe so, the Date table is made by Power bi with calendar funcation.

      • Baskar's avatar
        Baskar
        Resident Rockstar
        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.