Forum Discussion

R_'s avatar
R_
Regular Visitor
9 years ago
Solved

Rolling Sum for Max(Year)-1

Hi ,

 

Can anyone tell me how we can create Rolling sum till Last Year.

 

Regards,

R_

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi R_,

     

    -->  Create a date table that has continuos dates. 

    --.>Create a measure that calculates the sum of sales or order as per your scenario

    --> Rolling sum LY--> Calculate(Sales measure,sameperiodlastyear(datetable(dateColumn)))

     

    Regards,

    Hemant

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi R_,

     

    -->  Create a date table that has continuos dates. 

    --.>Create a measure that calculates the sum of sales or order as per your scenario

    --> Rolling sum LY--> Calculate(Sales measure,sameperiodlastyear(datetable(dateColumn)))

     

    Regards,

    Hemant

     

    • SivaMani's avatar
      SivaMani
      Icon for Resident Rockstar rankResident Rockstar
      9 years ago

      Hi R_,

       

      Create a measure like below mentioned formula,

       

      Rolling SUM =
      CALCULATE(
      SUM(CV_RETAIL_SALES_UNIV[Cost_Amount]),
      FILTER(
      ALL(CV_RETAIL_SALES_UNIV[Date]),
      YEAR(CV_RETAIL_SALES_UNIV[Date])<=YEAR(MAX(CV_RETAIL_SALES_UNIV[Date]))-1
      )
      )

       

      Regards,

      Siva

      • R_'s avatar
        R_
        Regular Visitor
        8 years ago

        Thanks but what if my finance year start from April-March..? How to calculate rolling year between that.?