Cumulative total minus another column

Question

Hi All,&nbsp;Its an enhancement to my earlier request. But not able to crack the logic. Please help.&nbsp;I simply want to do subtraction of CumulativeTotal - AnotherColumn based on the product category filter. Here is the sample data with some expected outputs.&nbsp;I was able to achieve the Green Column. But I am stuck on achieving the Yellow column.&nbsp;Sample data:&nbsp;ProductCategoryAmount_OneAmount_TwoAmount_ThreeCumulative of Amount_TwoCalculated Column 1 = IF(Table1[Category] = “Red”, [Amount_One]-[Amount_Two], [Amount_One]-[Amount_Three]]Calculated Column 2 = IF(Table1[Category] = “Red”, [Amount_One]-Cumulative of Amount_Two, [Amount_One]-[Amount_Three]]ARed1001090109090ARed200208030180170ARed300307060270240ARed4004060100360300ARed5005050150450350ARed6006040210540390BBlack7007030280670420BBlack8008020360780440BBlack9009010450890450BBlack100010005501000450BBlack1100110-106601110440BBlack1200120-207801220420

parry2k · Accepted Answer

vidyasagar159 I think this is what you are looking for, soluion is attached.
&nbsp;

Forum Discussion

Cumulative total minus another column

2 Replies

Related content

Cumulative Difference from Another measure

Cumulative Total

Sort by another column

Find Most Recent Date Relative to another Date Column in Power Query

Yet another Sort by another Column error.

Product	Category	Amount_One	Amount_Two	Amount_Three	Cumulative of Amount_Two	Calculated Column 1 = IF(Table1[Category] = “Red”, [Amount_One]-[Amount_Two], [Amount_One]-[Amount_Three]]	Calculated Column 2 = IF(Table1[Category] = “Red”, [Amount_One]-Cumulative of Amount_Two, [Amount_One]-[Amount_Three]]
A	Red	100	10	90	10	90	90
A	Red	200	20	80	30	180	170
A	Red	300	30	70	60	270	240
A	Red	400	40	60	100	360	300
A	Red	500	50	50	150	450	350
A	Red	600	60	40	210	540	390
B	Black	700	70	30	280	670	420
B	Black	800	80	20	360	780	440
B	Black	900	90	10	450	890	450
B	Black	1000	100	0	550	1000	450
B	Black	1100	110	-10	660	1110	440
B	Black	1200	120	-20	780	1220	420