Running total for 36 months

[davidell]

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

[v-yulgu-msft]

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