11 Replies Latest reply on Mar 21, 2018 3:19 AM by ade aiyeola

    Excluding Holidays and weekends  in Tableau

    dinesh reddy



      i am able to exclude weekends. Now i need to exclude public holidays from the same code.

      Foe excluding weekdays i used below logic


      DATEDIFF('week',[Event Start Date],[End Time]) *5


      MIN(DATEPART('weekday',[End Time]),6)


      MIN(DATEPART('weekday',[Event Start Date]),6)


      and now i want to exclude holidays from the above calculated field.