Forum Discussion

speterson's avatar
speterson
Regular Visitor
5 years ago
Solved

calculating SLA help

Hi there, I need help with a situation - need a column that will calculate if something is still open AND past its due date   IF column1 AND column2 AND column3 are null AND it is after DUE_DATE...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi speterson ,

     

    Check the formula.

     

    Column = IF(ISBLANK('Table'[SLA CBO])&&ISBLANK('Table'[SLA Completed])&&ISBLANK('Table'[SLA Cancels]),IF(TODAY()>'Table'[Client Due Date],"Open - SLA Missed","Open - Within SLA"))

     

    Best Regards,

    Jay

parry2k's avatar
parry2k
Super User
5 years ago

speterson what is after due_date_column?

 

Column = 
IF ( Table[Column1] == BLANK() && Table[Column2] == BLANK() && Table[Column3] == BLANK() &&
Table[WhateverColumn] > Table[DueDateColumn], 
Table[WhateverNewValueColumn], 
Table[WhateverOldValueColumn]
)

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • speterson's avatar
    speterson
    Regular Visitor
    5 years ago

    I might be in over my head here...let me try this again if you dont mind.

     

    I have 3 conditional colums I created to determine if a column has been completed on or before the "Client Due Date" that return one of the following 3 values "null", "SLA Achieved", "SLA missed"

     

    These columns are named

    -SLA CBO

    -SLA Completed

    -SLA Cancels

     

    If all 3 of the conditional columns above return "null" and it is currently AFTER the "Client Due Date" I need to return "Open - SLA Missed". 

    If all 3 of the conditional columns above return "null" and it is currently ON OR BEFORE the "Client Due Date" I need to return "Open - Within SLA".