calculating SLA help

[speterson]

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

[v-jayw-msft · Accepted solution]

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]

@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]

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