Turn around time notification / alert

[Riazq2]

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 that I have set the maximum processing turn around time to 15 days from the date of receipt of the loan application to final disbursal date. Based on the above I have calculated the turn around time by adding a custom column and subtracting the values of final disbursal date minus date of receipt of application. But I now further want that all loans that were processed beyond turn around time of 15 days or are still pending to appear on my dashboard notification / card that exceed the threshold / turn around time of 15 dyas. Please help me in this. 

[v-henryk-mstf]

Hi @Riazq2 ,

Whether the advice given by @lbendlin  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[Riazq2]

Hi Henry,

It has partly sovled my answer actually i want to create alert so that PBI can notify me as soon as the TAT exceeds. 

[lbendlin]

Create a Power Automate flow that periodically runs the DAX query and sends an email as needed.

[Riazq2]

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 · Accepted solution]

see attached

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523