Forum Discussion

DanielHolland's avatar
DanielHolland
Frequent Visitor
4 years ago
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"...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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"
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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's avatar
    DanielHolland
    Frequent Visitor
    4 years ago

    Thank you! Worked a treat 😄