Forum Discussion

kmcardle's avatar
kmcardle
Icon for Helper I rankHelper I
4 years ago
Solved

DaxTest11 = DATEDIFF('table'[Date/Time Opened],'table'[First Response],MINUTE) returns odd results

I am trying to return the number of minutes it takes to respond to a case.  I am using the formula: DaxTest11 = DATEDIFF('table'[Date/Time Opened],'table'[First Response],MINUTE) returns odd results ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Try this:

     

    My Time to Respond =

    VAR StartHour = HOUR(SRInsights-SupportCases'[Date/Time Opened]) VAR EndHour = HOUR(SRInsights-SupportCases'[First Response Date]) RETURN 

    IF (StartHour > 18 && EndHour < 8, [Whatever formula you need when after 6PM && before 8AM],

    (((DATEDIFF('SRInsights-SupportCases'[Date/Time Opened], 'SRInsights-SupportCases'[First Response Date], MINUTE))))

    --Nate

kmcardle's avatar
kmcardle
Icon for Helper I rankHelper I
4 years ago

If you have any thoughts that I can try.  I'd be so grateful.  

And please let me know if more information is needed.  This was my first post here and I wasn't 100% sure on whether people here prefer direct or verbose information.   Thank you all.