Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dommyw277
Helper II
Helper II

SLA Date Question

Hi, I have a created date and a closed by date. If the closed by date is prior to todays date its breached its SLA. Is there a calculation i could do to reflect this?

Hope it makes sense.

Example:  Created date 25/04/2022

                Close Deadline date 05/05/2022

Therefore this has breached the SLA as todays date is 03/05/2022

1 ACCEPTED SOLUTION

@dommyw277 , A new column like

 

if([Resolve By SLA Deadline] < today(), "SLA breached", "Not")

 

 

if([Resolve By SLA Deadline] > today(), "SLA breached", "Not")

View solution in original post

4 REPLIES 4
dommyw277
Helper II
Helper II

Thank you so much 🙂

amitchandak
Super User
Super User

@dommyw277 , You statement and example is not match

 

But you can create a column like

 

if([Close Deadline date] < today(), "SLA breached", "Not")

 

 

or

 

if([Close Deadline date] > today(), "SLA breached", "Not")

Hi, apologies

the 2 columns are :

Created Date Time

Resolve By SLA Deadline

@dommyw277 , A new column like

 

if([Resolve By SLA Deadline] < today(), "SLA breached", "Not")

 

 

if([Resolve By SLA Deadline] > today(), "SLA breached", "Not")

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.