Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Try this column
Cumulative Filed Bugs = CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, [Project] = EARLIER ( [Project] ) && [CreatedDate] <= EARLIER ( [CreatedDate] ) ) )
Try this column
Cumulative Filed Bugs = CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, [Project] = EARLIER ( [Project] ) && [CreatedDate] <= EARLIER ( [CreatedDate] ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |