Can anyone tell me how we can create Rolling sum till Last Year.
Go to Solution.
--> 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)))
View solution in original post
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))
Thanks but what if my finance year start from April-March..? How to calculate rolling year between that.?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!