Need a Column that adds reported Cumulative defects

[JeevanMallya]

I have a Table with Reported Defects and I want to create a New column that shows Cummulative by Considering ISSUE_KEY Columns with actual defects reported and ignoring null.I have added index column to run it iteratively.The Table looks like

PROJECT_KEY	ISSUE_KEY	Merged	CREATED_COUNT	Index	REPORTED_CUMMULATIVE
ABC	null	202201	0	1	0
ABC	null	202202	0	2	0
ABC	null	202203	0	3	0
ABC	null	202204	0	4	0
ABC	null	202205	0	5	0
ABC	null	202206	0	6	0
ABC	null	202207	0	7	0
ABC	null	202208	0	8	0
ABC	null	202209	0	9	0
ABC	null	202210	0	10	0
ABC	null	202211	0	11	0
ABC	null	202212	0	12	0
ABC	null	202213	0	13	0
ABC	null	202214	0	14	0
ABC	null	202215	0	15	0
ABC	null	202216	0	16	0
ABC	null	202217	0	17	0
ABC	null	202218	0	18	0
ABC	null	202219	0	19	0
ABC	null	202220	0	20	0
ABC	null	202221	0	21	0
ABC	null	202222	0	22	0
ABC	null	202223	0	23	0
ABC	null	202224	0	24	0
ABC	null	202225	0	25	0
ABC	null	202226	0	26	0
ABC	null	202227	0	27	0
ABC	null	202228	0	28	0
ABC	null	202229	0	29	0
ABC	null	202230	0	30	0
ABC	null	202231	0	31	0
ABC	null	202232	0	32	0
ABC	null	202233	0	33	0
ABC	null	202234	0	34	0
ABC	null	202235	0	35	0
ABC	null	202236	0	36	0
ABC	null	202237	0	37	0
ABC	null	202238	0	38	0
ABC	null	202239	0	39	0
ABC	null	202240	0	40	0
ABC	null	202241	0	41	0
ABC	null	202242	0	42	0
ABC	null	202243	0	43	0
ABC	null	202244	0	44	0
ABC	ABC-621	202245	1	45	1
ABC	ABC-624,ABC-630,ABC-631	202246	3	46	4
ABC	ABC-646,ABC-660,ABC-674,ABC-675,ABC-676	202247	5	47	9
ABC	ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691	202248	11	48	20
ABC	ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736	202249	14	49	34
ABC	ABC-754,ABC-802,ABC-803,ABC-811	202250	4	50	38
ABC	ABC-835,ABC-839,ABC-843,ABC-844,ABC-845,ABC-846,ABC-848,ABC-849	202251	8	51	46
ABC	ABC-850,ABC-856,ABC-863,ABC-865,ABC-866	202252	5	52	51
ABC	ABC-879	202253	1	53	52
ABC	null	202301	0	54	52

The expected Table should be

PROJECT_KEY	ISSUE_KEY	Merged	CREATED_COUNT	Index	REPORTED_CUMMULATIVE	REPORTED_CUMMULATIVE_ISSUE_KEY
ABC	null	202201	0	1	0	null
ABC	null	202202	0	2	0	null
ABC	null	202203	0	3	0	null
ABC	null	202204	0	4	0	null
ABC	null	202205	0	5	0	null
ABC	null	202206	0	6	0	null
ABC	null	202207	0	7	0	null
ABC	null	202208	0	8	0	null
ABC	null	202209	0	9	0	null
ABC	null	202210	0	10	0	null
ABC	null	202211	0	11	0	null
ABC	null	202212	0	12	0	null
ABC	null	202213	0	13	0	null
ABC	null	202214	0	14	0	null
ABC	null	202215	0	15	0	null
ABC	null	202216	0	16	0	null
ABC	null	202217	0	17	0	null
ABC	null	202218	0	18	0	null
ABC	null	202219	0	19	0	null
ABC	null	202220	0	20	0	null
ABC	null	202221	0	21	0	null
ABC	null	202222	0	22	0	null
ABC	null	202223	0	23	0	null
ABC	null	202224	0	24	0	null
ABC	null	202225	0	25	0	null
ABC	null	202226	0	26	0	null
ABC	null	202227	0	27	0	null
ABC	null	202228	0	28	0	null
ABC	null	202229	0	29	0	null
ABC	null	202230	0	30	0	null
ABC	null	202231	0	31	0	null
ABC	null	202232	0	32	0	null
ABC	null	202233	0	33	0	null
ABC	null	202234	0	34	0	null
ABC	null	202235	0	35	0	null
ABC	null	202236	0	36	0	null
ABC	null	202237	0	37	0	null
ABC	null	202238	0	38	0	null
ABC	null	202239	0	39	0	null
ABC	null	202240	0	40	0	null
ABC	null	202241	0	41	0	null
ABC	null	202242	0	42	0	null
ABC	null	202243	0	43	0	null
ABC	null	202244	0	44	0	null
ABC	ABC-621	202245	1	45	1	ABC-621
ABC	ABC-624,ABC-630,ABC-631	202246	3	46	4	ABC-621,ABC-624,ABC-630,ABC-631
ABC	ABC-646,ABC-660,ABC-674,ABC-675,ABC-676	202247	5	47	9	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676
ABC	ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691	202248	11	48	20	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691
ABC	ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736	202249	14	49	34	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691,ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736
ABC	ABC-754,ABC-802,ABC-803,ABC-811	202250	4	50	38	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691,ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736,ABC-754,ABC-802,ABC-803,ABC-811
ABC	ABC-835,ABC-839,ABC-843,ABC-844,ABC-845,ABC-846,ABC-848,ABC-849	202251	8	51	46	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691,ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736,ABC-754,ABC-802,ABC-803,ABC-811,ABC-835,ABC-839,ABC-843,ABC-844,ABC-845,ABC-846,ABC-848,ABC-849
ABC	ABC-850,ABC-856,ABC-863,ABC-865,ABC-866	202252	5	52	51	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691,ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736,ABC-754,ABC-802,ABC-803,ABC-811,ABC-835,ABC-839,ABC-843,ABC-844,ABC-845,ABC-846,ABC-848,ABC-849,ABC-850,ABC-856,ABC-863,ABC-865,ABC-866
ABC	ABC-879	202253	1	53	52	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691,ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736,ABC-754,ABC-802,ABC-803,ABC-811,ABC-835,ABC-839,ABC-843,ABC-844,ABC-845,ABC-846,ABC-848,ABC-849,ABC-850,ABC-856,ABC-863,ABC-865,ABC-866,ABC-879
ABC	null	202301	0	54	52	ABC-621,ABC-624,ABC-630,ABC-631,ABC-646,ABC-660,ABC-674,ABC-675,ABC-676,ABC-677,ABC-678,ABC-679,ABC-680,ABC-681,ABC-682,ABC-683,ABC-684,ABC-687,ABC-688,ABC-691,ABC-699,ABC-700,ABC-701,ABC-702,ABC-703,ABC-704,ABC-705,ABC-706,ABC-711,ABC-712,ABC-713,ABC-731,ABC-735,ABC-736,ABC-754,ABC-802,ABC-803,ABC-811,ABC-835,ABC-839,ABC-843,ABC-844,ABC-845,ABC-846,ABC-848,ABC-849,ABC-850,ABC-856,ABC-863,ABC-865,ABC-866,ABC-879

[danextian]

Hi @JeevanMallya 

Looking at the two tables, I don't see any difference.

[JeevanMallya]

There is a difference.REPORTED_CUMMULATIVE_ISSUE_KEY is a column with cummulative of ISSUE_KEY

[danextian]

Try this:

Cumulative Count = 
VAR _Tbl =
    FILTER (
        'Project',
        Project[PROJECT_KEY] = EARLIER ( Project[PROJECT_KEY] )
            && Project[Index] <= EARLIER ( Project[Index] ) --only index with less than or equal to current row index
            && NOT ( ISBLANK ( Project[ISSUE_KEY] ) )
    )
RETURN
    SUMX ( _Tbl, [CREATED_COUNT] )

[JeevanMallya · Accepted solution]

Thank you