SLA Status on Power BI Report

[DanielHolland]

Hi All, 

Im looking for Power Query formula to work out the "SLA Status" of My IT Tickets. 

Here is a Table im Working with and im looking to populate the "SLA Status" field Based on "Status", Todays date", "Expected Fix Date", "Closed Date" 

Is this Possible? Im then going to Display this in a Pie. which is traight forward.

Ticket ID	Status	Todays Date	Expected Fix Date	Closed Date	SLA Status
1	Open	01/04/2022	05/04/2022		On-Track
2	Closed	01/04/2022	06/04/2022	29/03/2022	HIT
3	Open	01/04/2022	29/03/2022		Breach
4	Closed	01/04/2022	29/03/2022	01/04/2022	MISS

Cheers 

Dan

[Vijay_A_Verma · Accepted solution]

Below is the formula

= if [Status]="Closed" and [Closed Date]>[Expected Fix Date] then "MISS" 
else if  [Status]="Closed" and [Closed Date]<=[Expected Fix Date] then "HIT" 
else if [Status]="Open" and [Expected Fix Date]>=[Todays Date] then "On-Track"
else "Breach"

[DanielHolland]

Thank you! Worked a treat 😄