Forum Discussion

javirmerino's avatar
javirmerino
Icon for Helper III rankHelper III
6 years ago

Date Time + x Working Hours (DAX)

First of all; thanks to everyone that's helped me out this week. I really appreciate it, guys!   I'm trying to calculate an expected end time and date based on a start time and a priority status so...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago

javirmerino   you could something like this, just need to adjust for your names

 

expected end time =
IF (
    isworkday = 1
        && isholiday = 0,
    issues[StartingPoint] + TIME ( RELATED ( lookup[Hours] ), 0, 0 ),
    BLANK ()
)

javirmerino's avatar
javirmerino
Icon for Helper III rankHelper III
6 years ago

Thanks vanessafvg, thats about as far as i got, too. This would be my solution if it were just adding hours, but i need it to add working hours only.

 

Somehow, the hours added timer needs to stop at 5pm and restart on 9am the next working day. The issue being that Low priority requests have a 40 hour SLA so they wouldnt even be due in the same week, let alone the same day!