Forum Discussion

Riazq2's avatar
Riazq2
Regular Visitor
3 years ago
Solved

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

Need Help

6 Replies

  • Riazq2's avatar
    Riazq2
    Regular Visitor
    3 years ago

    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 ApplicationLoan Disbursal DateTurnaournd Time Excees Days
    11-Nov-2215-Nov-2214 
    22-Nov-2216-Nov-2214 
    33-Nov-2216-Nov-2213 
    44-Nov-2217-Nov-2213 
    55-Nov-2225-Nov-22205
    66-Nov-2221-Nov-2215 
    77-Nov-2228-Nov-22216
    88-Nov-2220-Nov-2212 
    99-Nov-2225-Nov-22161
    1010-Nov-2226-Nov-22161
    1111-Nov-2227-Nov-22161
    1212-Nov-225-Dec-22238
    1313-Nov-2228-Nov-2215 
    1414-Nov-227-Dec-22238
    1515-Nov-228-Dec-22238
    1616-Nov-229-Dec-22238
    1717-Nov-2230-Nov-2213 
    1818-Nov-228-Dec-22205
    1919-Nov-226-Dec-22172
    2020-Nov-2213-Dec-22238
    2121-Nov-2214-Dec-22238
    2222-Nov-2215-Dec-22238
    2323-Nov-2216-Dec-22238
    2424-Nov-2217-Dec-22238
    2525-Nov-2218-Dec-22238
    2626-Nov-2219-Dec-22238
    2727-Nov-2220-Dec-2223

    8

    3

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Riazq2
      Regular Visitor
      3 years ago

      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's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

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