Forum Discussion
How to Dynamically Track Issue Status in Power BI
Hi everyone, I'm looking for help on how to add a custom "Status" column to an issue tracking table in Power BI. The "Status" column should track the current status of each issue based on its time...
Hi FreemanZ,
I'm not sure I understood your question.
I created a post initially which has not been very successful in terms of responses.
I have broken the problem down into easier parts. Maybe someone can help me. So, somehow it's a different problem.
Here is the table:
Zone | Issue | IssueAction | DateOfIssueAction |
1 | 10 | Reopened | 23-04-23 |
1 | 10 | Closed | 20-02-23 |
1 | 10 | Edited | 15-01-23 |
1 | 10 | Open | 14-01-23 |
1 | 11 | Open | 19-02-23 |
2 | 12 | Edited | 25-05-22 |
2 | 12 | Edited | 19-04-22 |
2 | 12 | Reopened | 17-04-22 |
2 | 12 | Closed | 15-04-22 |
2 | 12 | Edited | 14-03-22 |
2 | 12 | Open | 13-03-22 |
2 | 13 | Closed | 14-04-22 |
2 | 13 | Open | 18-02-22 |
3 | 14 | Closed | 17-03-22 |
3 | 14 | Open | 13-01-22 |
3 | 15 | Edited | 15-05-21 |
3 | 15 | Edited | 24-03-21 |
3 | 15 | Open | 22-01-21 |
Hi FreemanZ,
Zone Issue IssueAction DateOfIssueAction DesiredColumn(Status) 1 10 Reopened 23-04-23 Actif 1 10 Closed 20-02-23 Closed 1 10 Edited 15-01-23 Actif 1 10 Open 14-01-23 Actif 1 11 Open 19-02-23 Actif 2 12 Edited 25-05-22 Actif 2 12 Edited 19-04-22 Actif 2 12 Reopened 17-04-22 Actif 2 12 Closed 15-04-22 Closed 2 12 Edited 14-03-22 Actif 2 12 Open 13-03-22 Actif 2 13 Closed 14-04-22 Closed 2 13 Open 18-02-22 Actif 3 14 Closed 17-03-22 Closed 3 14 Open 13-01-22 Actif 3 15 Edited 15-05-21 Actif 3 15 Edited 24-03-21 Actif 3 15 Open 22-01-21 Actif