cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
R_ Frequent Visitor
Frequent Visitor

Rolling Sum for Max(Year)-1

Hi ,

 

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

 

Regards,

R_

1 ACCEPTED SOLUTION

Accepted Solutions
hemantsingh Member
Member

Re: Rolling Sum for Max(Year)-1

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

 

View solution in original post

3 REPLIES 3
hemantsingh Member
Member

Re: Rolling Sum for Max(Year)-1

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

 

View solution in original post

SivaMani Senior Member
Senior Member

Re: Rolling Sum for Max(Year)-1

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_ Frequent Visitor
Frequent Visitor

Re: Rolling Sum for Max(Year)-1

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

 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 338 members 3,295 guests
Please welcome our newest community members: