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

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 :-)

      • Vicentbi's avatar
        Vicentbi
        Frequent Visitor
        9 years ago

        Thanks Bro,

        I think it just worked

        I was missing 

         

        var end_Date = MIN('Calendar'[7Day Group])   -1 <--

         

        Thanks a lot.