Cumulative after a calculation

Question

So I have this table&nbsp;WeekEndingRevenue%NetCumulative Net2022-11-26&nbsp;&nbsp;&nbsp;&nbsp; 1,107.9414.8%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164.15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164.152022-12-03&nbsp;&nbsp; 15,507.6614.7%&nbsp;&nbsp;&nbsp;&nbsp; 2,281.45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,445.602022-12-10&nbsp;&nbsp; 45,913.6914.7%&nbsp;&nbsp;&nbsp;&nbsp; 6,740.76&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,186.372022-12-17&nbsp;&nbsp; 85,098.0614.7%&nbsp;&nbsp; 12,550.59&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21,736.952022-12-24&nbsp;&nbsp; 76,295.6414.6%&nbsp;&nbsp; 11,172.44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32,909.392022-12-31&nbsp;&nbsp; 68,372.4314.5%&nbsp;&nbsp;&nbsp;&nbsp; 9,929.34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42,838.732023-01-07&nbsp;&nbsp; 80,043.8214.4%&nbsp;&nbsp; 11,522.27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54,361.002023-01-14&nbsp;&nbsp; 91,107.9714.3%&nbsp;&nbsp; 13,037.08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 67,398.082023-01-21&nbsp;&nbsp; 81,853.0614.2%&nbsp;&nbsp; 11,660.92&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79,059.002023-01-28&nbsp;&nbsp; 71,401.5414.1%&nbsp;&nbsp; 10,072.15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 89,131.15&nbsp;So the goal is to calculate Cumulative NetTo get Cumulative Net we need to get the Net first&nbsp;Net = Revenue * %Cumulative Net = is the running total of the Net&nbsp;ThanksChris&nbsp;

freemanz · Accepted Answer

hi ChristianDGreat&nbsp;Cumulative Net =SUMX(&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp;TableName,&nbsp; &nbsp; &nbsp; &nbsp;TableName[WeekEnding]&lt;=MAX(TableName[WeekEnding])&nbsp; &nbsp; ),&nbsp; &nbsp; TableName[Revenue]*TableName[%])

Forum Discussion

Cumulative after a calculation

1 Reply

Related content

Cumulative Total

calculate cumulative sales for active products

Calculating cumulative total across categories

Calculating Cumulative Monthly Totals

Cumulative calculation with Calculated column

WeekEnding	Revenue	%	Net	Cumulative Net
2022-11-26	1,107.94	14.8%	164.15	164.15
2022-12-03	15,507.66	14.7%	2,281.45	2,445.60
2022-12-10	45,913.69	14.7%	6,740.76	9,186.37
2022-12-17	85,098.06	14.7%	12,550.59	21,736.95
2022-12-24	76,295.64	14.6%	11,172.44	32,909.39
2022-12-31	68,372.43	14.5%	9,929.34	42,838.73
2023-01-07	80,043.82	14.4%	11,522.27	54,361.00
2023-01-14	91,107.97	14.3%	13,037.08	67,398.08
2023-01-21	81,853.06	14.2%	11,660.92	79,059.00
2023-01-28	71,401.54	14.1%	10,072.15	89,131.15