Forum Discussion

davidell's avatar
davidell
Frequent Visitor
8 years ago

Running total for 36 months

Hi guys.

I've been searching in the community but I was not able to find out how to create a running total for 36 months for order intakes?

I want to use a Line Chart, in which I can show the running total for 36 months. 
So the X axis should contain Jan 2015, February 2015...........Jan 2016, February 2016........Jan 2017, February 2016.  I'm interested in looking a three years marked as months on my X-axis
 

Thank you very much

Regards,

Davids

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi davidell,

     

    You can first sort the date column in asecnding order and add an index column in Query Editor mode. Then, create a calculated column, referring to below DAX:

    Running Total =
CALCULATE (
    SUM ( Table1[index] ),
    FILTER ( Table1, Table1[index] <= EARLIER ( Table1[index] ) )
)

    For more advice, please provide detailed sample data and show us your desired output with image.

     

    Best regards,
    Yuliana Gu