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_COLUMN then NEWVALUE

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

3 Replies

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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    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