Forum Discussion
Rolling 12Month SUM
Hi, I wanted to calculate rolling 12 months sum but the formula below seems doesn't work. Please help.
Rolling 12 Months =
CALCULATE(sum('Table'[LC]),DATESINPERIOD('CALENDAR'[Date],ENDOFMONTH('Table'[DATE]),-12,MONTH))
Here is the sample data.
Incorporate a CORRECT calendar table, which should contain all days of any month.
4 Replies
- ThxAlot
Super User
Incorporate a CORRECT calendar table, which should contain all days of any month.
- Ashish_Mathur
Access Denied message.
Hi Ashish_Mathur , can you try this link?
https://drive.google.com/file/d/1xuRPLABB_3j12UoH4aNIZrrMc7FcD-5i/view?usp=sharing
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.
