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

     

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.?