Skip to main content

I've come across another issue in Tableau. I am trying to count the number of working days between two dates. I used the following calculation which works, however it still includes holidays.

 

([Date Complete]-[Date Received])-

if

(DATEDIFF('year',[Date Received], [Date Complete]))>=1

then

(2*((DATEPART('week', [Date Received]) + 52*DATEDIFF('year',[Date Received], [Date Complete])) - DATEPART('week', [Date Received])))

else

(2*(DATEPART('week', [Date Complete]) -DATEPART('week', [Date Received])))

end

 

I also have another data sources I have connected to that determines business days and holidays, but I'm not sure how to successfully connect the two sources.

3 answers
  1. Oct 28, 2014, 4:50 PM

    There are some other threads on this Forum that are related, not sure what may help you here (didn't view your workbook) but here's one that may be of use:

    The specified item was not found.

0/9000