cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sprasad Member
Member

Incremental summing of values based on conditions

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 IdProjectCreatedDateClosedDateStateCumulative Filed BugsCumulative Closed Bugs
3225Project A01-02-18 17:0606-02-18 8:59Closed11
3227Project A01-02-18 17:5006-02-18 8:56Closed22
3228Project A01-02-18 17:5206-02-18 13:47Closed33
3229Project A01-02-18 17:5705-02-18 17:56Closed44
3230Project A02-02-18 10:0908-02-18 8:43Closed55
3298Project A05-02-18 17:2007-02-18 6:20Closed66
3299Project A05-02-18 17:23 New7 
3316Project A05-02-18 18:33 New8 
3317Project A05-02-18 18:39 New9 
3325Project A06-02-18 17:40 New10 
3326Project A06-02-18 17:41 New11 
3330Project B07-02-18 12:2613-02-18 15:13Closed11
3352Project B08-02-18 5:4615-02-18 11:56Closed22
3363Project B09-02-18 14:1909-02-18 17:21Closed33
3364Project B09-02-18 14:5022-02-18 7:51Closed44
3365Project B09-02-18 14:53 New5 
3377Project B09-02-18 21:18 New6 
565Project B28-09-17 16:40 New7 
1343Project B27-11-17 5:51 New8 
2129Project B08-12-17 4:1906-04-18 5:40Closed91
2136Project C11-12-17 11:1525-04-18 4:00Closed12
2535Project C19-12-17 12:0013-04-18 6:35Closed23
4620Project C30-03-18 10:49 New3 
4769Project C03-04-18 15:28 New4 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Incremental summing of values based on conditions

@sprasad 

 

Try this column

 

Cumulative Filed Bugs =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER (
        Table1,
        [Project] = EARLIER ( [Project] )
            && [CreatedDate] <= EARLIER ( [CreatedDate] )
    )
)
Try my new Power BI game Cross the River

View solution in original post

1 REPLY 1
Super User III
Super User III

Re: Incremental summing of values based on conditions

@sprasad 

 

Try this column

 

Cumulative Filed Bugs =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER (
        Table1,
        [Project] = EARLIER ( [Project] )
            && [CreatedDate] <= EARLIER ( [CreatedDate] )
    )
)
Try my new Power BI game Cross the River

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors