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,
| 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 |