Line Charts with Cumulative values

[GaRaGe]

 I have my data like this (image below)

Now i need to create a line chart in Power BI. I am getting something like this (sample image below)

Just for illustration i used this chart (Target and Actuals are two lines). 

Now i need the lines to be cumulative over months. How can i do that in Power BI?

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[BlueMan]

thanks that fixed it using DATESYTD, but why wouldn't the other method work? 

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark that as Answer.  You were simply not using the correct function.

[sushmasushma]

Hiiii

I have data like this

Number	Company	Date	Operating Revenue	Profit after Tax	ROCE (%)	Operating Margin (%)	Net Margin (%)	EPS Growth (%)
1	TIL(Grove)	17-Mar	325.31	26.45	14.37	62.5	5.3	160.68
		16-Mar	1,736.27	-43.59	9.43	6.68	-2.5	-1,023.51
		15-Mar	1,471.56	4.72	11.74	10.65	0.32	-52.47
		14-Mar	1,312.58	9.93	10.14	9.45	0.75	130.39
		13-Mar	1,173.65	4.31	8.49	8.25	0.36	-71.9
		12-Mar	1,381.60	15.34	10.38	6.47	1.1	-74.51
		11-Mar	1,376.10	60.19	24.56	9.83	4.35	1.12
2	Eicher	7-Mar	0	31.37	71.04	-	99.46	1,928.10
		6-Mar	0	1.55	5.78	-	34.5	-51.39
		5-Mar	0	3.18	11.16	-	84.79	102.12
		4-Mar	0	2.86	1.76	-	94.39	131.39
		3-Mar	555.37	-9.11	3.54	6.48	-1.62	17.26
		2-Mar	-	-	-	-	-	-
		1-Mar	-	-	-	-	-	-

I want company name as y axis and 

Date

Operating Revenue

Profit after Tax

ROCE (%)

Operating Margin (%)

Net Margin (%)

EPS Growth (%)

This row i want x axis it is possible Plz suggest me

Thank you

[Greg_Deckler]

Actually, if you have the April release, you could just use a Running Total Quick Measure. Right click your "Spend" column to create.

[Greg_Deckler]

I would start here:

http://www.daxpatterns.com/cumulative-total/