Cumulative after a calculation

[ChristianDGreat]

So I have this table

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

So the goal is to calculate Cumulative Net

To get Cumulative Net we need to get the Net first

Net = Revenue * %

Cumulative Net = is the running total of the Net

Thanks

Chris

[FreemanZ · Accepted solution]

hi @ChristianDGreat 

Cumulative Net =

SUMX(

    FILTER(

       TableName,

       TableName[WeekEnding]<=MAX(TableName[WeekEnding])

    ),

    TableName[Revenue]*TableName[%]

)