Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous there are tons of posts on such calculations, here is link to some

 

Solved: Trailing 12 or Rolling 12 month sum - Microsoft Power BI Community

 

Rolling 12 Months DAX Measure in Power BI - YouTube

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡