Forum Discussion
Solved
SLA Status on Power BI Report
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
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"
2 Replies
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"Thank you! Worked a treat 😄
