Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX - Calculating SLA's

Hi all,    Got an odd one that I could use somehelp with please. I have a set of data that has an [Enquiryreceived] datetime and a [Closeddatetime] amongst other bits and have 3 possible Service Le...
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

The "treat as" is a clue.

Maybe create a date or date/time column that holds the date the "treat as date".

Then the calculate of whether if falls into SLA 1 or 2 becomes simple.

I don't know if you're using a date/time calendar table, which might be one place to calculate the "treat as" date, or if it might work better to calculate it in a query as a calculated column in DAX. Both ways would separate the calculate if, if logic from the decision of which SLA the enquiry should fall under

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the reply - some colleagues and I managed to troubleshoot this by changing the way we interpreted the question. Instead of considering it to have come in at 08:00 Monday we knew that it had to be closed by 5ppm Monday to be within SLA. The change in perspective opened it up for interrogation.