Rolling 12 months

Question

Hi all,&nbsp;I'm trying to calculate rolling 12 months,&nbsp;Rolling 12months = CALCULATE(&nbsp; &nbsp;[TotalCases],&nbsp; &nbsp; DATESINPERIOD('Merge'[CASE_DATE],MAX(Merge_Annual_Mx_Vss[CASE_DATE]),-12,MONTH))&nbsp;What I'm sorting is for Rolling 12 months, 2022Q3 = 2186&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2022Q4 = 2186+1914=4100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2023 Q1=2186+1914+886=4986&nbsp;&nbsp;I'm a bit stumped that this is not working for me, and I am not sure what I'm missing.&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

devika , Always use the date table joined with date of your table. If possible use the Window function 
&nbsp;
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH))
Rolling Months Formula: https://youtu.be/GS5O4G81fww
&nbsp;
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

Forum Discussion

Rolling 12 months

2 Replies

Related content

12-month rolling cumulative

Rolling 12 Month calculation

12 month rolling turnover

DAX rolling 12 months and last year

12 Month Rolling average.