Running Total & Cumulative % by DAX

[srehman]

Hi Team,

I have calculated all fields by using pivot table, but i need to calculate again some fields by using DAX.

I have calculate by using DAX

% Month =DIVIDE([Total Order],CALCULATE([Total Order],ALLSELECTED(),VALUES('Pick Report'[Month])))

Now i have to calculate (Running or cumulative total of each month product) & ( Cumulative Percentages). ( Whatever product by each month as i did in pivot table) ---> Need in DAX

Each product have multiple order per day per date.

I am unable to attached snapshot exceeding limit it is only 321k data.

!Karcher Slotting New Model.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
2	Pivot table									By Pivot table
3	Pivot table									Month				Month
4	Count of Orders	Month								1				2
5	SKUs	1	2	3	4	5			SKUs	Ord Per Month	% Mont	Runn Tot	% Cumm	Ord Per Month	% Mont	Runn Tot	% Cumm
6	15163160	545	442	488	7	6			15163160	545	2.58%	545	2.58%	442	2.19%	442	2.19%
7	62958900	474	273	289	218	213			62958900	474	2.24%	1019	4.83%	273	1.35%	715	3.55%
8	15131420	488	336	310	111	199			15131420	488	2.31%	1507	7.14%	336	1.67%	1051	5.22%
9	69591300	250	248	288	247	283			69591300	250	1.18%	1757	8.32%	248	1.23%	1299	6.45%
10	26431470	336	166	141	238	333			26431470	336	1.59%	2093	9.91%	166	0.82%	1465	7.27%
11	26439080	263	240	217	293	255			26439080	263	1.25%	2356	11.16%	240	1.19%	1705	8.46%
12	13241130	387	303	270	169	250			13241130	387	1.83%	2743	12.99%	303	1.50%	2008	9.97%
13	16021240	332	287	263	217	274			16021240	332	1.57%	3075	14.56%	287	1.42%	2295	11.39%
14	16298490	191	173	371	260	199			16298490	191	0.90%	3266	15.47%	173	0.86%	2468	12.25%
15	62957500	257	177	181	165	72			62957500	257	1.22%	3523	16.68%	177	0.88%	2645	13.13%
16
17
Sheet4