Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago
Solved

Calculating Working Days between multiple events

Hi, I would like to calculate the Working Days only for a Case between Received and Resolved dates. This is easy if it was just that simple because occasionally a Case can be put on hold (deferred) ...
Need Help
Show and Tell
YukiK's avatar
YukiK
Impactful Individual
3 years ago

You can get working days like this:

CALCULATE(
    COUNTROWS ( 'Date2' ),
    DATESBETWEEN ( 'Date2'[Date],  'Cases'[Date Received], 'Cases'[Date Resolved] ),
    'Date2'[Is Working Day?] = TRUE,
    ALL ( Date2 )
)
ArchStanton's avatar
ArchStanton
Power Participant
3 years ago

This isn't what I was after as I already have this code. The other respondent in this thread has nailed it so all good now.

Thanks for your input anyway!