Incremental summing of values based on conditions

[sprasad]

I have these columns in my database, I need to find out the incremental Filed bugs (column F) and incremental Closed bugs (Column G) date wise w.r.t project so that in the graph I can display the line as Bugs filed each date vs bugs fixed each date and filter based on the project. Any clue or help is really appreciated.

Bug Id	Project	CreatedDate	ClosedDate	State	Cumulative Filed Bugs	Cumulative Closed Bugs
3225	Project A	01-02-18 17:06	06-02-18 8:59	Closed	1	1
3227	Project A	01-02-18 17:50	06-02-18 8:56	Closed	2	2
3228	Project A	01-02-18 17:52	06-02-18 13:47	Closed	3	3
3229	Project A	01-02-18 17:57	05-02-18 17:56	Closed	4	4
3230	Project A	02-02-18 10:09	08-02-18 8:43	Closed	5	5
3298	Project A	05-02-18 17:20	07-02-18 6:20	Closed	6	6
3299	Project A	05-02-18 17:23		New	7
3316	Project A	05-02-18 18:33		New	8
3317	Project A	05-02-18 18:39		New	9
3325	Project A	06-02-18 17:40		New	10
3326	Project A	06-02-18 17:41		New	11
3330	Project B	07-02-18 12:26	13-02-18 15:13	Closed	1	1
3352	Project B	08-02-18 5:46	15-02-18 11:56	Closed	2	2
3363	Project B	09-02-18 14:19	09-02-18 17:21	Closed	3	3
3364	Project B	09-02-18 14:50	22-02-18 7:51	Closed	4	4
3365	Project B	09-02-18 14:53		New	5
3377	Project B	09-02-18 21:18		New	6
565	Project B	28-09-17 16:40		New	7
1343	Project B	27-11-17 5:51		New	8
2129	Project B	08-12-17 4:19	06-04-18 5:40	Closed	9	1
2136	Project C	11-12-17 11:15	25-04-18 4:00	Closed	1	2
2535	Project C	19-12-17 12:00	13-04-18 6:35	Closed	2	3
4620	Project C	30-03-18 10:49		New	3
4769	Project C	03-04-18 15:28		New	4

[Zubair_Muhammad · Accepted solution]

@sprasad 

Try this column

Cumulative Filed Bugs =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER (
        Table1,
        [Project] = EARLIER ( [Project] )
            && [CreatedDate] <= EARLIER ( [CreatedDate] )
    )
)