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

 

 

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.

       

       

       

       

      • Baskar's avatar
        Baskar
        Resident Rockstar
        9 years ago

        ALLExcpet also work .

         

        Try this Replace Date in Allexcpet with Dimension name.

         

        I hope this will also works for u :-)