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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I do not understand.  What result are you expecting?

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.

    • pcray's avatar
      pcray
      Frequent Visitor
      8 years ago

      Hi

      thanks for the proposal

      Not sure if i have entered it correctly as its not working in two ways.

      1. its showing an error

      2. its not showing a cumulative running total

      thanks in advance for suggestions on how to fix it

      Peter 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Share the link from where i can download your file.