Forum Discussion
Turn around time notification / alert
I have calculated turn around time based on the values in two columns i.e. in my department staff loans are processed so I want to keep an eye on the performance of staff processing the loans for tha...
see attached
Please find attached sample data. I want power bi to let me know when the threshold of 15 days exceeds. My dashboard alert notification should send me alert that the cases received 15 days before are still pending. But I don't know if this can be achieved for multiple values as the card only checks for a single value and based on the same it generates alert as per pre-defined criteria.
| S. No. | Date of Receipt of Application | Loan Disbursal Date | Turnaournd Time | Excees Days |
| 1 | 1-Nov-22 | 15-Nov-22 | 14 | |
| 2 | 2-Nov-22 | 16-Nov-22 | 14 | |
| 3 | 3-Nov-22 | 16-Nov-22 | 13 | |
| 4 | 4-Nov-22 | 17-Nov-22 | 13 | |
| 5 | 5-Nov-22 | 25-Nov-22 | 20 | 5 |
| 6 | 6-Nov-22 | 21-Nov-22 | 15 | |
| 7 | 7-Nov-22 | 28-Nov-22 | 21 | 6 |
| 8 | 8-Nov-22 | 20-Nov-22 | 12 | |
| 9 | 9-Nov-22 | 25-Nov-22 | 16 | 1 |
| 10 | 10-Nov-22 | 26-Nov-22 | 16 | 1 |
| 11 | 11-Nov-22 | 27-Nov-22 | 16 | 1 |
| 12 | 12-Nov-22 | 5-Dec-22 | 23 | 8 |
| 13 | 13-Nov-22 | 28-Nov-22 | 15 | |
| 14 | 14-Nov-22 | 7-Dec-22 | 23 | 8 |
| 15 | 15-Nov-22 | 8-Dec-22 | 23 | 8 |
| 16 | 16-Nov-22 | 9-Dec-22 | 23 | 8 |
| 17 | 17-Nov-22 | 30-Nov-22 | 13 | |
| 18 | 18-Nov-22 | 8-Dec-22 | 20 | 5 |
| 19 | 19-Nov-22 | 6-Dec-22 | 17 | 2 |
| 20 | 20-Nov-22 | 13-Dec-22 | 23 | 8 |
| 21 | 21-Nov-22 | 14-Dec-22 | 23 | 8 |
| 22 | 22-Nov-22 | 15-Dec-22 | 23 | 8 |
| 23 | 23-Nov-22 | 16-Dec-22 | 23 | 8 |
| 24 | 24-Nov-22 | 17-Dec-22 | 23 | 8 |
| 25 | 25-Nov-22 | 18-Dec-22 | 23 | 8 |
| 26 | 26-Nov-22 | 19-Dec-22 | 23 | 8 |
| 27 | 27-Nov-22 | 20-Dec-22 | 23 | 8 3 |
- lbendlin
Super User
see attached