Forum Discussion
12 month rolling sum
I'm currently trying to get a 12 month rolling sum for each month. Year Month Count 12 Month Rolling 2017 November 20 20 2017 December 25 25 2018 January 30 30 2018 Febru...
Hi Anonymous ,
You could add a date column in the table.
date = DATE('Table'[Year],'Table'[number of Month],1)Then create a measure as below.
Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALLSELECTED('Table'),'Table'[date]>=SELECTEDVALUE('Table'[date])&&'Table'[date]<=EDATE(SELECTEDVALUE('Table'[date]),12)))Best Regards,
Jay
Hi Anonymous ,
You could add a date column in the table.
date = DATE('Table'[Year],'Table'[number of Month],1)Then create a measure as below.
Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALLSELECTED('Table'),'Table'[date]>=SELECTEDVALUE('Table'[date])&&'Table'[date]<=EDATE(SELECTEDVALUE('Table'[date]),12)))
Best Regards,
Jay