Rolling Sum

[pareke03]

Hi Everyone,

I am fairly new to Power BI and struglling a lot to understand how to add a calculated column that does rolling sum based on Month (String), Cost Center and Cost Element. I have a table like below:

Year	Month Name	CC	CE	Actual	Cumulative Sum
2015	Jan	101	201	12	12
2015	Jan	102	202	13	13
2015	Jan	103	203	14	14
2015	Feb	101	201	10	22
2015	Feb	102	202	11	24
2015	Feb	103	203	12	26

So based on Cost Center (CC), Cost Element (CE) and Month Name I want to do rolling sum of Actuals. E.g. YTD Sum of CC 101 and CE 201 on Feb-15 was 22 (10+12). Since it is year to date rolling sum Jan 15 number doesn't depend on Dec-14 but also need to consider this as I have data from 2013 to 2016.

How do I make this happen. Can anyone please suggest a formula?

Really appreciate your time.

Best,

Keyur Parekh