Forum Discussion

pcray's avatar
pcray
Frequent Visitor
8 years ago
Solved

cumulative previous year

Hi,

Can someone help me to create the previous year cumulative running totals

this is what i have for last 12 months running cumulative total

Need Help
  • pcray's avatar
    pcray
    8 years ago

    Hi

    just to let you know i was able to get it working in the end.

    cheers

    peter

6 Replies

    • pcray's avatar
      pcray
      Frequent Visitor
      8 years ago

      Hi

      where the arrow is, i would like to add in a new measure to show a cumulative running total for the previous year.

      peter

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Try this measures

         

        Total sales last year rolling = CALCULATE([Total Sales],DATESBETWEEN(Calendar[Date],EDATE(Min(Calendar[Date]),-12),EDATE(Min(Calendar[Date]),-12)))

         

        Hope this helps.