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.
Hello experts,
I am trying to receive "number of open bugs" grouped by
- project
- the end of particular period week / quarter / year
and based on CREATED and RESOLVED dates columns.
Measure Open issues is a total count of created issues until the period end minus a total count of resolved issues until the period end. We consider the issue resolved if it has a resolution date.
The complex moment is, that we need to check both columns, CREATED and RESOLVED in order to make desicion about calculation. We should count all P1, P2, P3, P4 if
Pseudo code:
foreach date X (end of particular period) {
if date X > date[CREATED] AND (date[RESOLVED] IS EMPTY OR date[RESOLVED]>date X)
SUM(P1);
SUM(P2);
SUM(P3);
SUM(P4);
}
Solved! Go to Solution.
@viktork , I have blog on HR, very similar current employee.
See if that can help
https://www.youtube.com/watch?v=e6Y-l_JtCq4
Thank you Amit,
This is exact solution for my case. Really appreciate your help!
@viktork , I have blog on HR, very similar current employee.
See if that can help
https://www.youtube.com/watch?v=e6Y-l_JtCq4
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |